The geometry of warped product singularities