For that reason, the NIMBY forces / politics against nuclear are much stronger than average (both in building the plant and storing the waste). Never mind that, on average, nuclear power is much safer than fossil fuels. People fear the spectacular more than the mundane. Take terrorism vs. car crashes, in the Western world you're more likely to die in a car crash by far, but it's terrorism that stirs up the fears.
As far as global warming is concerned, power generation is only part of the puzzle anyways. Such contributors as transportation and deforestation are also important. Honestly, solar and wind are pretty competitive right now... except for one angle. The main problem with solar / wind / etc. energy generation right now is variability, so the real "moonshot" for this technology is energy storage. (Which is the same real issue with electric transport as well).