Why is earth at 0 V with respect to phase?
Yes, in some grounding schemes (eg. TN) N is grounded at the power station end and that is what makes N = E.
In some other systems like IT, N is not grounded and the Ls are floating.

Look up grounding schemes/grounding systems.