I'm ignorant, and so I am probably a good case study on why folks can't just "get behind" nuclear. I am told that the nuclear accidents of yesteryear are outliers, and were due to old technologies, and those types of meltdowns just can't happen using new technology. Is it true? I don't know. But I do know this. Nuclear gives folks pause because when things go wrong, they go wrong for millenia. Because radiation is f*$!*ing terrifying.
For me personally to feel alright about nuclear, I would need to know that those plants are resilient to catastrophic events that may occur every few thousand years or more. We saw what an earthquake/tsunami did to Fukishima. If a nuclear power plant were to be built in Clancy, Montana, I would want a guarantee that an earthquake, a wildfire, a microburst, and even an asteroid impact, would not cause Clancy, Montana to be an uninhabitable wasteland for the next 20,000 years, as other nuclear meltdown sites are destined to be. One could argue that something like an asteroid impact is so unlikely, but when the consequences are measured in millenia and are so absolute I want assurance against events that are only plausible on timescales measured in millenia.
I haven't looked into nuclear deeply, and as was said above, there is no such thing as a free lunch. But the whole "Guys, guys guys, that was old tech, it will be different this time", is an industrial tale as old as time, and rhymes with tragedies of yesteryear, and looks and quacks like the hubris duck.
To be clear, I am not arguing for any form of power generation, nor am I arguing against nuclear. These are just the offhanded thoughts of a mapmaker who had corned beef hash for breakfast.