No. NEVER PLUG A 12V POWER SOURCE INTO A USB 3 EXPRESSCARD. USB is a 5V standard and it is not designed to take 12V. Applying a 12V source may damage the card, will void the warranty and may damage any connected USB peripherals.
None of Sonnet's Cards with USB 2.0 or USB 3 (either Type A or Type C) ports support the Apple SuperDrive. You must use a built-in USB 2.0 or 3.0 port on your Mac.
According to http://support.apple.com/kb/HT5630, "The Apple USB SuperDrive is compatible with Mac models from 2008 and later that don't have a built-in optical drive."