It’s not like they are plaintext, and increased availability/ redundancy would be one potential reason for deciding to have a cloud synced password manager database.

There are other solutions that you can self host or create yourself, and if that works better for you and your use case, I encourage it.