Suppose the first point is the north pole. By concentration of measure for the sphere, a randomly chosen second point is almost guaranteed to be almost on the equator, so the limit should be $\sqrt{2}$.