Please note though that the "forever" timescale becomes harmless for all intents and purposes relatively quickly. So IMHO and I don't really know the cause, this conception we have of nuclear is a really uninformed one. See: https://www.quora.com/How-long-does-nuclear-fallout-last
"Today, the liveliness of the cities of Hiroshima and Nagasaki serves as a reminder not only of the human ability to regenerate, but also of the extent to which fear and misinformation can lead to incorrect expectations. After the bombings of Hiroshima and Nagasaki, many thought that any city targeted by an atomic weapon would become a nuclear wasteland. While the immediate aftermath of the atomic bombings was horrendous and nightmarish, with innumerable casualties, the populations of Hiroshima and Nagasaki did not allow their cities to become the sort of wasteland that some thought was inevitable. This experience of can serve as lesson in the present when much of the public and even some governments have reacted radically to the accident in Fukushima--in the midst of tragedy, there remains hope for the future."
Ok, but more than 30 years after the Chernobyl disaster, it's still not safe to live in Pripyat. Worker's are limited to spending no more than 5 consecutive hours on site.
Maybe it is uninformed, but the media certainly doesn't help in it's coverage of nuclear disasters. Speaking as someone with very little understanding of nuclear physics and energy, how it seems like nuclear power plants are amazing right up until they don't work (see Fukashima, 3 Mile Island, Chernobyl) or the fuel rods are spent. We still don't have long-term nuclear waste storage plans other than cordoning off certain areas and burying the spent fuel underground[1]. From the same article, nuclear plants have massive 'ponds' 7-12 meters deep that store highly radioactive spent fuel rods for a few years until they reduce their reactivity and heat to something more manageable before disposing of them. When decommissioning a nuclear station, what do we do with that water when in the meantime? Especially if it really is true that a nuclear plant's lifetime is on the order of 50 years[2].
Don't get me wrong, maybe nuclear is the optimal answer to Earth's energy needs. But also, maybe the tech is just not there yet, and certainly the media's fear-mongering needs to be more tempered and more informative to allow public acceptance of nuclear. Otherwise we will probably still keep getting NIMBY responses
I'm not quite sure what your question is with the spent fuel pool. The water will just sit there and slowly evaporate probably or be cleaned and checked for contaminants before going elsewhere. It's really not that much water. I think you're making a problem where there isn't one.
The water keeps it from melting as the spent fuel becomes a little more inert each day (it transfers heat to the water, and as we know radioactive stuff has half lives). After a few years, we can move it to dry storage (incased by concrete and steel).
"Today, the liveliness of the cities of Hiroshima and Nagasaki serves as a reminder not only of the human ability to regenerate, but also of the extent to which fear and misinformation can lead to incorrect expectations. After the bombings of Hiroshima and Nagasaki, many thought that any city targeted by an atomic weapon would become a nuclear wasteland. While the immediate aftermath of the atomic bombings was horrendous and nightmarish, with innumerable casualties, the populations of Hiroshima and Nagasaki did not allow their cities to become the sort of wasteland that some thought was inevitable. This experience of can serve as lesson in the present when much of the public and even some governments have reacted radically to the accident in Fukushima--in the midst of tragedy, there remains hope for the future."