Personally speaking, I find Star Fox (and most on-rails shooters) incredibly boring. Visually for the time it's impressive, but I'll play Corncob on my PC or any of the Jane's games because they provide more gameplay.
As far as "nobody was ever going to use it", that's incorrect (as the success of the Retron series shows). My parents among others were highly resistant to buying me any console because we were a PC family - Genesis was the only one I could get them to even budge on because it had access to a library of cheaper games in addition to the expensive stuff. Part of the reason I didn't get a 7800 was because they'd picked the TRS-80 CoCo over the 2600 and we didn't have the library of software at the ready. If they'd included an NES on a chip, and I could have convinced at least two of my friends to let me borrow their NES carts in addition to SNES stuff, I might have had a SNES.