So in other words, Passkeys are over engineered and simply too complicated for most users.

Succumbing to lock-in can smooth some (but not all) rough edges and creates it's own restrictions and risks.

TOTP for the win --- it's the simpler practical alternative.