Ah yes, create db replica, promote replica to primary. Seems so simple!

When I’ve seen this work well, it’s either built into the product as an established feature, or it’s a devops procedure that has a runbook and is done weekly.

Doing it with low level commands and without a lot of experience is pretty likely to have issues. And that’s what happened here.