we’ll have to create a new SSN system and everyone will need new SSN’s after spending our whole lives remembering the same one.

Hopefully the new one would have proper security features, rather than having one single number that every bank, lender, employer, etc has. It desperately needs the ability to revoke access for just a single entity, which is impossible if they all share the same number.