Water contamination from naturally occurring uranium is a bigger risk than nuclear waste (uranium, like lead, can cause heavy metal poisoning independent of radioactivity). Chemical waste from non-nuclear industries are far more hazardous than nuclear waste, yet the latter is for some reason an enormously larger concern. If you're worried about generational risk, there are plenty of things an order of magnitude more concerning than nuclear waste.