It can be thought of as a combination of "son of a bitch" + "damn" + "motherfuck."
"Son of a mother duck" is a phrase appropriate to be shouted for both epic WINS and epic FAILS. It's also more appropriate for saying by younger people who are too chicken to use adult expletives.
2. I can't believe I died again in CoD4: Modern Warfare 2. For the 27th time. In the SAME spot. Arrgh! SON OF A MOTHER DUCK!!! *Smash controller into wall or floor.*