Supported, but reported wrong. On the first glance, off the top of my head, without checking his other claims, those are supported features, that are red
Row constructor
SELECT FOR UPDATE ... NOWAIT
IP address datatype
RETURNING clause
You keep quoting this sql-workbench guy, a if he'd be some kind of authority. He's not, and he is biased. A lot of red in MariaDB column can be green, if he researched better.
Now, if we look at your laundry list, and a "real" database, like Oracle
Oracle - Weird UTF8 - check. Actually, WTF-8, encodes supplemental character as 6 bytes, incorrectly, while the original MySQL's utf8mb3 just does not allow them, and is otherwise a strict subset of real UTF8
Oracle - No transactional DDL - check.
Check constraints - 5 years ago, MariaDB
I think you might reconsider your "To get a sense of you're talking about, compare Oracle ..." sentence. Maybe remove Oracle from that list?