Lylat Wars was amazing, probably the best game in the series, however its a reboot of the first game so its expected. Its the direction Star Fox took after the N64 game. Star Fox Assault wasn't done very well and Star Fox Adventures.. is not a Star Fox game which to me was a massive let down. Star Fox Zero tried to bring back the original idea but failed with the controls. Star Fox 2 actually felt like the first game just with a RTS Map screen between missions with more variety but it was extremely short which would have been another key factor why the game was dropped.
Yeah Starfox 2 is the only game in the series that feels like a proper sequel to me. As for it being short, I doubt that was why it was dropped, it's not really any shorter than the first game, and it plays out differently each time so it's highly replayable.
Bet with Liquidlaser: I say PS5 and Xbox Series will sell more than 56 million combined by the end of 2023. (And over 130 million lifetime)