I don't think it is very effective, but that because I now cringe every time that ad's music comes on. *shudders*
But the target audience is probably the kids who usually watch TV at that time. And I am sure for all of them the song gets them enough to bug the hell out of their parents.