Dams are a good analogy, here. Dam failures can be catastrophic and far, FAR worse in life lost than even worst-case nuclear failures. The 1975 failure of the hydroelectric Banqiao Dam killed between 100,000 and 230,000 people and destroyed 11 million homes. https://en.wikipedia.org/wiki/Dam_failure

Nuclear power is worth the risk when faced with the threat of climate change. At very least, we must keep existing plants operating until we decommission all fossil fuel power plants.