I was also struggling to grasp the difference, so maybe some examples could help.
MCAR: Missing completely at random, this is great. It means that the non-response is completely random. So your survey is not biased.
MAR: Missing at random, worse situation. Imagine you are asking for IQ and you have much more females participants than males. Lucky for you, IQ is not related to gender, so you can control for gender (apply weighting) to reduce bias.
MNAR: Not missing at random, bad. Consider having survey for level of income. And again, you have more females than males participants. In this case, this is a problem, because level of income is related to gender. Therefore your results will be biased. Not easily to get rid of.
You see, it is a "triangle" relationship between target variable (Y, such as income), auxiliary variable (X, such as age) and response behavior (R, the response group). If X is related to R only, good-ish (MAR). If there is relation between X and R and X and Y, its bad (MNAR).