Maximum depth of penetration is the ratio of the densities of the projectile and the matter to be penetrated times the length of the projectile. Harpoons have a higher density than water and are quite long, so they work.