The article is not actually about observability and why it requires a columnt store but a marketing article about Honeycomb's database, IMO. The topic is better explained in another article they link to - https://www.honeycomb.io/blog/so-you-want-to-build-an-observ... .
Also while PostgreSQL as well as MySQL were initially row-based DBs, they both nowadays support columnt store. PostgreSQL supports it via Citus and MySql (MariaDB) supports it natively.