MMS limitations are only relevant because Apple makes them relevant. I have never sent or received an MMS outside of the iMessage interoperability context. This is obviously deliberate.
You can send whatever you want through SMS, as a link.
The GP comment is about sending media between iPhone and Android, and claims that that is limited by MMS. That’s obviously not true. And has nothing to do with SMS/MMS.