DOC: improve docs to clarify MultiIndex indexing
As per our discussion in #16943. Let me know what you think. I'm not quite happy with the new warning box, ideas how to improve the message are welcome.