And secondly, if you do end up with q distributed systems, remember how many independently failing components there are because thag directly translates to complexity.
On both these counts I agree. Microservices is no silver bullet. Network partitions and failure happen almost every day where I work. But most people are not dealing with that level of problems, partly because of cloud providers.
Same kind of problems will be found on a single machine also. Like you'd need some sort of write ahead log, checkpointing, maybe optimize your kernel for faster boot up, heap size and gc rate.
All of these problems do happen, but most people don't need to think about it.
You'll also likely use multiple databases (caching in e. g. Redis) and a job queue for longer tasks.
You'll also probably already have multiple instances talking to the databases, as well as multiple workers processing jobs.
Pretending that the monolith is a single thing is sneakily misleading. It's already a distributed system
Making a system to be reliable is really really hard and take many resources, which seldom companies pursuit.
Each of them introduces a new, rare failure mode; because there are now many rare failure modes, you have frequent-yet-inexplicable errors.
Dead letter queues back up and run out of space; network splits still happen;