On macOS Tahoe, the Passwords app does put the keyboard focus in the password field on launch.

Password field with focus How does Apple mess up something as fundamental as keyboard focus? Are they now vibe-coding macOS?

Source: macOS Golden Gate is a buggy mess

To be fair, we are still in 27.0.1. However, apart from reverting a terrible UX decision, the raw edges of Golden Gate are showing up more and more.