In a sentence
Play moderately softly: fuller than p, gentler than mf.
Mezzo piano sits between p and mf in the dynamic family. The word mezzo means medium, modifying piano rather than replacing it.
Its purpose is often structural: a passage can step out of the background without becoming assertive. Hear it against its neighbours, not as an absolute volume reading.