So you have:
a) No enforceable isolation, reliance entirely on good behaviors and module systems
b) No independent scaling
c) No isolation of security components so instead of a minting service and an edge service you have one service that does both
d) Single language lock-in
I could go on and on an don
There is ScyllaDB for a much better reimplementation of Cassandra/Dynamo, but wide-column databases are still best for niche scenarios, especially as RDBMS are rapidly evolving into natively distributed architectures.
Everything from StackOverflow to ad serving systems to high-frequency trading exchanges are run this way.
Quora, Pinterest, Twitter, etc are all just big app instances talking to DB instances, with separate systems for background processing, queues, and caching. Are you suggesting that they would scale better with serverless functions instead?
Here's a list of architectures: http://highscalability.com/all-time-favorites/
... of course, the best-paying jobs are at the places that really do need that scale, so of course we all want an excuse to play with those tools, even when it's not the right business choice. And it's not as if software folks are the only ones with a principal-agent problem, in business. Oh well.
I dislike using boring as a measure of sufficiency. It makes me wonder if those drawn to the clever solutions carry a "I know better than you" perspective, the kind of dogmatic optimism that tanked SVB.
With most services, until you go over a few million users concurrent users, you really don't need to horizontally scale.