Here's one
source with a technique for straightening a bent pin: It states, "If a pin is bent, straighten it with the end of a retracted mechanical pencil, reconnect the cables, turn on the computer, and try again." I was going to suggest small needle-nose pliers for this, but apparently the mechanical pencil idea means retracting the lead so that the end of the pencil can be fitted on the pin and then tilted in whatever direction is necessary to straighten the pin.
Regarding the pin that only "half visible from outside", I don't know what to tell you; I don't know whether it's safe to pull on it with small needle-nose pliers to see whether you can pull it back out to the normal position. Are you absolutely sure part of it is not broken off?
You might be able to find a shop that could repair it. Of course, that might cost nearly as much as a new drive, depending on the size of the drive. But, if you have valuable data that's at risk of being lost, the cost of repair may be worthwhile.