The only Pilotwings I actually played was Pilotwings Resort, which was a launch title for the 3DS, at the store. I thought videos of Pilotwings 64 were pretty impressive for their time. I never saw the SNES game in action.
The first line of your review really shows how times have changed. The NES (with Super Mario Bros in the US), Game Boy (Tetris and Super Mario Land), SNES (Super Mario World, Pilotwings, etc) and N64 (Super Mario 64) all launched with strong titles designed to showcase their systems. I guess Wii Sports falls into this category as well even though Wii games like Xenoblade, The Last Story, and Fire Emblem are more my speed.
For other systems, their good games didn't come until the consoles had been out for a year or two. Even Nintendo hasn't been launching with the same kind of system-showcasing titles since the Gamecube, while Sony and Microsoft have always had kind of lackluster launches. That said, the PS3 and 3DS, my current favorite systems, both launched with rather weak launch titles, and look at them now!