I’m not sure if I understand your current problem correctly, but I assume that your problem are the existing users, which have no “connected social login account”. When all users are connected everything would be fine?
As you wrote already yourself, the email is not unique in Nextcloud and therefore can not used safely for user mapping.
When I switched to the sociallogin app, I conencted the existing users with a simple SQL query. I exported the Discourse user list and inserted a mapping for the [internal name]-[userid] (e.g. kb2-3797) to the existing Nextcloud usernames into the sociallogin_connect table in the nextcloud database. What fields you use for mapping (e.g. username or email) depends on your setup.
The screenshot seams a little bit outdated, but I have a very similar table (including the “button to create a new device-specific password”) when I open /settings/user/security on my Nextcloud 23.0 stable instance. Can you post a screenshot of your page?