Give people time to respond...patience is the key. Since it says the card is locked, is there a physical switch on the card to lock and unlock it?
You are seeing the drives pop up because you likely have a multi-card reader, and when a card is inserted, the drive letters will show for each format it can read. My USB card reader uses four drive letter when plugged in, even if I only have one card inserted.
If your attempts at recovery software aren't working, then it is possible the drive is toast. Flash memory is unreliable, so data should never be stored on them that can't be replaced. Wait for more answers, but that is a likely outcome.