Bummer!
So now the question is can you find another broken one on eBay which has a good connector assembly and can you swap the part out?
Sounds like you’re half way to a guide here ;-} If you take on the challenge you can help others! By taking notes and pictures as you figure it out and post your discovery here! [https://www.ifixit.com/Contribute]
It’s people like you that help us chip away! Help support the '''''Right to Repair!'''''