Existential is as you mentioned: ground water pollution of the entire NE seaboard. Terrorist dirty bomb in NYC that affects 30 million people as the weather carries particles etc.
Again, waste storage is incredibly secure and safe. It wouldn't leech into the water. Nuclear subs have sank into the ocean, and, surprise, there wasn't a global disaster.