But we just cannot as a species deal with such long term risks - risks that extend far beyond the length of even the most long lasting of past human civilizations.
I think the fact that otherwise well informed, technically savvy members of this forum can say things like "spent fuel is not really a problem" demonstrates that.
I don't think that technical minded people who say
"spent fuel is not really a problem" are asking to ignore long term risks. I think what they are reflecting on is that storing lots of potential energy - in whatever form it happens to be in - can be a poison pill.
First: lets get NIMBY out of the way - if a dam in California breaks - it is their problem. And sure, coal emissions only heat up the other side of the world and cause cancer to "those" people. And many agree fossil fuels seem limitless. But that is turning a blind eye - the risks and grave dangers inherent by ANY storage of potential energy are only ignored by the same types who live on the slopes of Mount Vesuvius and are afraid of pressure cookers. It is "those" people.
Get over it - potential energy is generally safe if it is 12V on a 100uF capacitor - Anything over that is asking for trouble and utterly dangerous.
And YES: Radiation is scary; Global warming is scary; Lead pollution is scary (any pollution is scary); Dams collapsing is scary; Flying turbine blades are scary (even if they are very high up and very big). Heck - even a hand-granade is scary (and that is some cockamamie potential energy in the form of piddling chemistry - not enough to kill a fly a 100 yards away...); I even get scared standing on the ledge of a cliff - potential energy is (and should be) scary.
The only thing substantially scarier than storing potential energy is NOT having it when we need it.