What it genuinely fixes
A whole-region outage, and latency for a globally distributed audience. Both are real problems; neither is the problem most sites actually have.
The cost is correctness, not money
Data must be replicated, and replication brings consistency decisions, conflict resolution and a far harder debugging story.
Cheaper steps first
Multiple availability zones, tested backups and a documented restore give most of the resilience for a fraction of the complexity.