The reality is that it's a hypothetical problem. Even the simple real problem of storing spent fuel is not that of a problem, because there's not that much of it. And while it's hot it needs water then moving air anyway.
Long term storage is a nice idea, but in reality it's easy (dump anywhere down enough that it doesn't matter) and the later we solve it the more certain we can be that we did it right (more data, more time spent on finding the right solution).
It doesn't really help with costs, so there's no hurry, and it's a political quagmire. So it just did not happen. (WIPP kind of happened, and is happening, but it's for non-commercial nuclear waste.)
https://en.wikipedia.org/wiki/Onkalo_spent_nuclear_fuel_repo...
My rational judgement is not in question here, but that of all anti-nuclear proponents should be. And you're right, I do have strong feelings. Can you really blame me? I'm inheriting a broken world that looks existential climate change in the face, shrugs, lights up a spliff and says "well solar is pretty cheap". We've had the technological solution to climate change in hand for 60+ years: rocks so spicy they'll power our entire civilization for millenia. Yet we (the people) got outplayed so hard by the oil lobby that not only is nuclear energy on the decline, threads like these where supposedly technologically literate people espouse greenpeace's old talking points abound. And while this baseless and frustrating 'debate' continues, the water rises.