Hi,
The one broken pin might be important, so having it missing won't help. Might be cheaper in the long run to buy a usb dvd drive. More cumbersome but alternatively maybe cheaper than getting connector fixed.
You could always try, very very carefully straightening out the remaining bent pins. you don't want to break off any more (remove the battery first), plugging it back in and see how it performs. You might be lucky. as the missing pin might only be necessary for a function that can be otherwise overcome. make sure that the "missing pin" is still not sitting in the connector area or anywhere else in the laptop for that matter.