The hypothetical upper bound of a reactor accident is that 1 radioactive atom gets inhaled by each creature on Earth and the decay of that atom causes a fatal cancer and every living thing dies.
There are ~equally unlikely life-ending upper bounds of all energy sources. For example, you could have world-ending wars and famines from solar and wind if a superlarge volcano largely blocks out the sun for a few years. Or they could lead to world-ending land wars over sunny and windy areas.
Today, in reality, we have clear and present and known dangers like fossil and biofuel that are currently killing millions and also causing climate change. These things make 84% of our primary energy as a world today. Shifting away from these things to the things low on the ourworldindata graphic above (low carbon, low risk) is a net benefit. Worrying about exceedingly unlikely worst cases is not necessarily productive or useful. Considering them is well and good, sure. But IMHO one must dismiss them quickly based on 60 years of operational experience.
In other words, if someone is currently attacking you and you can pepper spray them, it's probably better to do so than to worry about whether or not the pepper will cause the house to combust.