Refraction is indeed the reason the archer missed. When light passes from inside the water to the air outside, it bends causing the image of the target to appear to someone outside the pool to be in a different position. This is due ultimately to the difference of electric permittivity between water and air.