So the threat model of a "normal user" is that one of their reused passwords will be breached and released, and these services prevent that.
If you are in the situation of being specifically targeted because of a system you have access to, you have an entirely different threat model and should consider the tradeoffs in light of that.
The centralization can't really be avoided and is also somewhat a separate issue. You can weigh the benefits and risks of doing it yourself, keeping it in a physical book or stack of postits, paying one of these companies etc but it has to happen if you're truly using unique passphrases and none of these is free from risk, either of discovery or unrecoverable loss.
- Rotating important passwords, so old copies are less useful
- Bucketing into multiple vaults, easier with file based tools like KeePass, though you could have separate accounts on various SAAS vaults
- Requesting to be forgotten from old services, especially those which have shared PII and passwords
- Hardware 2FA
It is intellectually similar to the argument that "the cloud providers might have downtime, but they're probably going to have less than your private DC due to the economies of scale and returns on investment in reliability"