I think that's exactly the point where the article falls flat. There is potentially a big oppurtunity in building a SSG + CMS solution despite the past failed attempts.

Every few years I go looking for something that's not Wordpress that you could hand to a marketing department, but there is no viable alternative (that's not Drupal).

There's a number of headless CMS solutions for commercial websites. Hosted, multi-user, paid. It's just a different category.

That is where headless CMS with Vercel and Netlify partnerships, using Next.js SSG capabilities come into play, regardless how much folks hate them.