The answer is we'll need all of the above.
I don't think wind and solar are red herrings at all, although they're not a silver bullet, either.
Ex: Half your home energy usage is for hot water. Everyone focuses on photovoltaics, which are the least cost effective and most expensive home technology, but what homes really need is passive solar, which requires no more energy to produce that a standard plumbing system. A friend as a system here in seattle, and it produces all of his hot water for 6 months a year, and half for the rest of the year. He supplements it with an on demand water heater, which is in itself more efficient than a tank unit. The payback for these systems is about 5 years in Seattle.
So...how many passive solar water heating systems do you see around your neighborhood? How about in new construction?
That's the problem. We haven't even begun to conserve. And that's just one example out of many where, with proper planning and new construction techniques, we could cut our energy usage per capita in half at least...and still live as well as we do now.
As for wind, the new windfarm at Vantage will power 70,000 homes at average output. Not bad for just getting started.
A new company is now producing biodeisel from fast growing algae. Soon, a cellulose based biodeisel will be available, which will make favorable the energy in vs energy out equation for that fuel.
My point is: let's max out these clean technologies before we 'gladly make the tradeoff' (ie: selfishly fuck future generations in the ass with a hotter planet).