Some routine maintenence and losing your balance while holding a hard drive and ripping the cord out breaking the retainer for the connectors..... 4tb Samsung ssd RIP
Seconded. If OP lives anywhere near a city, there's probably an electronics repair shop within reach that would solder on a new connector for less than the cost of a new SSD.
Having all pins present, I wouldn’t be surprised if the drive still gets detected while bending a SATA cable back juuuuuust right so its connector makes contact with the pins.
I've used computers for years like that, also these card edge connectors are pretty standard and can be easily replaced by anyone who can do basic soldering.
It's really easy. I have be soldering to repair my own guitars since I was like 12. Watch an instructional video on the internet, practice with some spare wires and circuit boards. You can learn in an hour or two.
I did this to a PNY drive once and they RMAd it for me! I was up front and said it was 100% my fault and I had already had it for a few years. If you've got a laptop that has a mounted slot you can probably slide it in to get any data you need off of it