I think the title is a little misleading.
It looks like Intel is introducing two new models (E6600 and E3400), and moving the others downstream. Both look to be attractive products for the cost, especially when you consider the low power use.
People can scream about quad core this and that, but for the average person who surfs, goes on facebook, instant messages, etc..., these products are powerful enough, and come with a very low power use. Quad core isn't necessary for everyone.
Also, most people don't care about the socket the processor is installed on going away, for the simple reason most people don't upgrade processors. I've never seen the point myself. By the time your processor is old, you're probably better off replacing the motherboard too. At least most of the time.