There are two types of security keys in Discourse: first factor (aka passkeys) and second factor. The passkey can be used to log in from the main login screen, before you have entered a password. The second factor key can only be used after entering a password, that’s why it is called a second factor, because it’s after a first authentication step.
I can see that in your account you have a second factor key, that’s why you are getting the “Authenticate with Security Key” prompt. I also see that you have a passkey too, from Windows. Can you try logging in with that? Do you still have that after resetting Windows?
If that doesn’t work, you can ask the administrator at TruckNet to reset the hugh_lorry account’s security keys. The admin would need to agree that you’re the rightful owner of the account. If they do and remove the key, then you can log in via email without a 2FA because there won’t be one anymore on that account.