> How does a password manager help my cloud account?

It's an alternative place to store webauthn credentials, if you're worried about being locked out.

> What does enrolling multiple credentials even mean?

You register multiple passskeys for your account on a service. So if you lose access to one (because you yoinked your phone into orbit), you can use the other one.

It's as complicated as you want to make it.