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.