The risk is different. For coal, more or less everybody gets a few years off of their life expectancy, some a bit more who live closer to a plant, but roughly speaking, it's something everybody suffers from. With nuclear, those who live closer to a plant risk much more devastating damage in case something goes wrong. If you normalize both then nuclear comes out much safer, but that's not how humans work. I live 60km from a very old reactor that is 20 years past its designed runtime, has several shutdowns a year, had a few leaks "that didn't pose any danger to people". We just gonna keep it running because nothing bad happened yet, until something bad happens. Capitalism at work.
But indeed the waste storage is by far the greatest problem. Not for us luckily, we get some cheap electricity and coming generations can deal with the waste we shoved in some hole. Expecting that the way we store the waste is safe for thousands of years is naive. Germany hasn't found a final destination and is just shipping that stuff around. Someone thought it was a good idea to store it near east Germany, until east Germany was no more and suddenly it was in the middle of the country in an unsuited location. Someone thought it was a good idea to store it in a salt mine, until the containers started corroding from salt water. But that was back when humans were still stupid and didn't know salt water corrodes things. Luckily we reached end of history now and do everything right. I'm positive the next location will not be picked by political motives.