I figure I would download and play it on my mp3 player overnight hoping it might stick subconsiously. Could that work hypothetically?

Hypothetically? No. Not learn, anyway. Your mind needs to be awake to organise the data.
You’ll probably absorb random information just as you’re waking up, when your mind’s at its most lucid and suggestible. But in this state it won’t be able to assimilate the info correctly. It will just make random connections and subconscious associations.
So not a method I’d use. If I did, I’d probably find myself in a restaurant in Rome asking for an enema.

you could use it to improve pronunciation skills.
I bet only marginally. Again any benefit would come from half-waking periods, not actual sleep, and I bet it would just help you get the rhythm and intonation patterns of the language, if that.