Only ~3% of nuclear waste is really dangerous, that's the spent fuel rods. The majority of "nuclear waste" is stuff that was in proximity and contains intermediate to low levels of radioactivity. It's obviously not great to injest or spend all your time around, but it can be safely stored almost anywhere as it's mostly only emitting alpha and beta particles.

So what about the dangerous stuff like fuel rods? Well, if you took all the dangerous waste nuclear power ever created and piled it in one place, it would cover a football field and be stacked 3 meters high. That sounds like a lot, but remember, that's is ALL the dangerous waste nuclear power has EVER produced. Compare that to literally any other form of energy production, including solar and wind, and the footprint from nuclear is laughably, almost unimaginably, small.