can I repair part fried socket
Option 1: finding a replacement connector. Exact fit might be difficult.
Option 2: replace by using a donor part. Find same model drive and swap part.
Option 3: hotwire power by directly soldering to pcb traces.
Option 4: board swap. (complicated)
Option 5: sending it to professionals.

This all assumes only the connector failed due to being a cheap sata power adapters. And no failure in the drive itself.