Once you reset the password using the recovery mode, the saved passwords
on keychain are all lost. This means you need to connect your Wi-Fi
again, enter your email passwords, iCloud password, etc.
I also have the same issue. I guess this is an issue on macOS Sonoma. I
had to exclude the computer from the password policy to fix this. Anyone
else have a solution?