It is more correct to say that air because it compresses dissipates explosions. Water doesn't amplify them, but it is still going to be a lot worse than air.
My guess is water protects from nuclear radiation and they get confused. Anyone else want to guess where the trope came from?