pkernstock this extension works just like the core extensions worked in the past.
It's all email-based. Whether you previously logged in with a social login doesn't matter.
If you use social login and an account already exists with that email, you will be logged into it.
If you have an account that only used social login, you can use the forgotten password feature to set a password and enable password login.