It looked pretty good for the time. Couldnt do real time 3D rendering and also be fast (StarFox was truly 3D; but iirc also ran at like 15fps and had to use a special chip in the cart to do that), so they compromised with sprites made from pre-rendered 3D models.
It also had great level design and memorable music.