The N64 was a success. Just because it didn't do as well as the PSX doesn't mean it was a failure. The N64 gained a good-sized userbase, had lots of games that sold multi-millions, and Nintendo actually made more money off of it than Sony made off the PSX.
The Gamecube isn't a failure either but it's certainly a lot closer to being one than any Nintendo console should ever be. But, let's be honest, Nintendo deserves this after being stupid enough to give the PS2 such a huge head-start and not even having any really amazing system-selling launch titles when it FINALLY got it's new system out.
So, at most, Nintendo has about half a strike (which it deserves) and that's it.