I didnt even realize it was a Mountain Dew Commercial which is part of the problem. The disturbing image on the screen made me not care who the advertiser was. People are saying did you see thePuppyMonkeyBaby not did you see the Mountain Dew Commercial.
I guess it varies for everyone, but I thought it was effective. Caught my attention in "WTF" fashion and held it through to the product advertised - Mountain Dew drink that combines three things: Dew, caffeine and juice. Okay, I don't remember the name of the specific product, but it comes in a purple can so I could find it pretty easily.
In other words, the weirdness actually tied into the product, unlike other commercials that are weird just for the sake of it. Mountain Dew commercials have been pretty out there since the 90s. This fits in with their overall strategy and demo just fine.