Shooting the gun underwater isn't the problem, unless you are also submerged. The blast pressure will blow out you ear drums, at the very least. Let's remember that water it something like 20 times denser than water.
If you are on the bottom of the pond and shoot a BMG, you will not be swimming to the surface