I can probably confirm what happens! … After the period you’ve stated in : purge_unactivated_users_grace_period_days
the username should become available again.
I still don’t understand how much rare it would be for someone to all of a sudden ditch social sign in and start the registration flow again.