I'm reading the book "The Finite Element Method: Theory, Implementation, and Applications" by Larson and Bengzon. In the first chapters there are presented two methods for approximating polynomials. There is the statement that the $L^2$-projection $P_hf$ is the best approximation to $f$ when measuring the error $f-P_hf$ in the $L^2$ norm and I understand the proof of it. However, when I look at the examples provided (L2-projection linear interpolation), the $L^2$-projection "looks" like a worse approximation. It's also said that linear interpolation is exact at nodes $x_i$, when $P_hf$ gives a good on average approximation, but it also doesn't "look" that way.
Could someone explain why is it that way? Is it because we're measuring the error in the $L^2$ norm, which somehow behaves unintuitively? If yes, then why would we use that norm? And also, I thought that $L^2$ norm is sort of the equivalent of Euclidian norm for functions.