Initially I've also struggled with this, and the mental model I found most useful is that a passkey is used to log in into that account from that device.

If the website doesn't allow you to add multiple passkeys then that's bad ux and that's on them.