Well, I don't think you're "most" people.
Imagine if you could have a P&S with a 3G data connection ( as opposed to a 3G device with a camera attached.) That would open up a huge market if you could upload your P&S pics straight to your social network of choice

Yeah, I'm not like most people. I like some technology, but dislike most of it. lol I may eventually get one, but it won't be an Apple and it may take another 10 years before I do.
You can get a Eye-Fi wi-fi card to go in your camera. It will upload your pictures directly to the site of your choice. You just need to find a wireless hotspot it can connect to. The Pro version will even upload your RAW pictures to your computer via wireless (a great way to shoot "tethered"). But an 8GB card runs about $100. The JPEG version is cheaper though.
I don't think P&S cameras will go away, but like others have said, they numbers of them will drop.



