I never understood the privacy concern that americans have about a national ID card when the government knows all the same things about them, and can abuse it in all the same ways. It's like having all the downsides of a national ID, without the upside of being protected against identity theft.
And as to why the SSN is the way it is, it's a usage of convenience. Before the SSN there was no unique identifier for every citizen then suddenly to keep track of the new entitlement and assistance programs during the great depression one was created and companies started using it as they wanted because it was the most convenient uuid available. There's a good recent CGP Grey video about the history of SSN and why it's such a silly mess today.
Keeping us afraid is good business for a lot of low-rent grift industries, like doomsday preppers, as well as high-level ones, like the military industrial complex.
Obviously that Id can't be kept secret.
In Ukraine we even have an opt out for crazy Russian churchgoers who believe, that having id is literally selling their soul - they just use passport number in their x509 certs.
A true solution would have to be usable by private industry as well. If it were up to me, it would essentially be x509 (because today, you're trusting the state and the person presenting the SSN), but people lose important shit, even proof of identity, all the time.