Great point.
It's a bit like cars, who needs 150mph top speeds? But the engine efficiencies required for a car to run at such a speed might just benefit the average user, the braking systems would be just as effective put to use on a family saloon.
Most folk don't need anything more than 6MP.
It is handy to have some more though, if you need to correct skews and crop for example.
There are some interesting by-products of the pixel race though...
In order to squeeze more pixels onto a sensor the enginneers are decreasing the gaps between pixels, increasing the amount of amplification that can be added before noise becomes a problem, and these technologies trickle down and will benefit the next generation of users.
If you could take a 10MP cropped sensor camera and redesign the chip with gapless sensors then each of the 10MP photosites could be physically larger, requiring less amplification, if you then couple that with technology that means even when you add amplification it is barely detected until very high settings, then you have many more practical applications for the cameras.
Because higher pixel counts require more processing then the cameras have to pack more power.
I would rather a well sorted 10MP camera than a noisy or soft 21Mp camera any day.
There are some who have a valid application for monsterously high resolutions, so be it, as long as I have a choice when my camera finally dies I'm not bothered.
I'm all for the top end cameras pushing the boundaries and the technology trickling down. The fact that the two most popular professional cameras are the Canon EOS 1D Mk3 and the Nikon D3 (10Mp and 12MP respectively) show that it isn't all about resolution, speed, low light and processing ability are as much of an issue.
To answer your question though, I think for most consumers who don;t know about physics or how cameras work, it becomes a game of top trumps. Biggest, fastest, shiniest, most expensive blah blah blah.