Your question deserves a serious and well thought-out answer. It has been discussed back and forth on this forum before, and everyone has their own spin on it. You might get an answer of sorts from Sean Malstrom's Disruption Chronicles, but that might be a bit long-winded and highflying for your taste (not to mention offensive).
In short, I would say that the reason the Wii is succesful is BECAUSE it does not appeal to you. How many "hardcore-gamers" do you think is out there, really? Not that many, in comparison to the amount of people there are. Why should one go after such a small group of people, really, when there's a massive group that is uncatered to?
Those that do not play games (mothers, grandfathers, teenage girls... everyone except for the 14-35 year old male, really) have never really been considered by the industry. Because they don't play games, so why make games they want to play?
The answer to that question, naturally, is to simply point at The Sims, the Touch Generation games, Guitar Hero and Singstar. When games try to really do something fun or useful for the people outside the traditional group of gamers, they succeed big-time.
All in all, I think that you should not be worried about the Wii's success. What it will do is that it will open more people up to gaming as a concept, and you'll be getting less stares at work when you say you own a PS3, and someone might even want to join you in a game of Buzz or Singstar.
Isn't it better overall if all types of people can enjoy gaming rather than just a tiny group of people (like you)?