It has already been solved, and a search should tell you all about it.
I'm still on mobile, so sharing links is still a pain, but a few key things:
Nuclear waste is produced quite slowly, so whatever cost you associate with storage is over a large period of time; we have the technology to build centrals that can use that waste to produce more energy, reducing waste even further.
The materials you are classified as "low level waste", and they are "materials which contain small amounts of mostly short-lived radioactivity", and they actually make up 94% of waste in the Uk, but according to this article, it's 95%.
96% of spent nuclear fuel is Uranium, which can be reused.
Purely anecdotal; here's a different anecdote.
Here's is also a National Geographic article about this topic, and here is another.
Here is also the mortality rate of different sources of energy in 2012, and here it is in 2022. You'll notice that after heavy R&D in renewables, nuclear is still the second safest; with all top three being really close, but hydro being a far 4th.
Please stop with the fear based, anti-scientific, rhetoric. I shouldn't feel like I'm arguing with climate deniers or pro oilers when talking with supposed environmentalists. Which reminds of the reason why this is so important: renewables alone still can't meet the energy demand without the assistance of fossil fuels, and the energy requirements keep rising:
"Clean sources of generation are set to cover all of the world’s additional electricity demand over the next three years" - they are accounting for nuclear, but nevertheless: "Low-emissions sources are expected to account for almost half of the world’s electricity generation by 2026".
Almost half, by 2026, accounting for nuclear. And we are still getting warmer.