If you're looking for a more general explanation, and not one only about OP_RETURN, I would suggest reading https://bitcoinops.org/en/blog/waiting-for-confirmation/