Personally, outside of the online mode, I don't enjoy it all that much. No on-rails is a big no-no, and most of the enemies just fly around in a straight line and fire randomly. The only time I had the slightest bit of fun in single player is vs. Star Wolf, but Nintendo had to dumb them down since you don't have your wingmen supporting you.
Just remake the original Star Fox already damnit (*with* the original Corneria theme).