My experience of testing in sandbox has been the new sounds playing on the first few shots fired, then either playing the old explosion sound with the new aftershock sound, or just the old explosion sound by itself. It seems like it might have something to do with the distance of the explosion from the camera or the artillery piece.