As seen here: SoundController Arma 3 Wiki.

The Water Soundcontroller is not working for CfgAmmo classes. If it were able to use this controller to detect if, for example, an explosion is happening in water, it would be possible to have different sounds for explosions inside and outside of water, which would highly benefit the variety and immersion!