Major Super NES classic here and the first game I think of when I think of their 1993 lineup. (The system would absolutely explode in 1994, the year I got it, with a litany of incredible games that defined the whole gaming generation).
Star Fox is mostly a showcase for the Super FX Chip, which let the SNES make use of three-dimensional polygon graphics for the first time ever. ...and this particular tech didn't really stick around, so it's a bit of an artifact now. While the 3D effect is quite rudimentary, and the system was in most regards better off sticking to 2D (which it largely did after this), there's still a place for this game in the SNES lexicon. Nothing else was like it at the time.
As for my own experience with it, this was one of the many SNES games I rented circa 1995 or so. Had a great time with it as a kid. However, I was only able to beat the first of the three level paths. That first path is the one the vast majority of players did, so only beating the game on easy mode (ostensibly) is nothing to be ashamed of. However, I've been wanting to revisit it and finish the other two paths ever since. Now I finally have an excuse to.
Playing this on Nintendo Switch Online. It's cool how things like this and Capcom Arcade Stadium are making emulation less necessary to revisit retro games, as well as letting me revisit them on a TV.