There is lots of confusing and unnecessary blah, blah, blah before they get into the subject and the song lyrics are quite complicated for a 2 year old to fully understand what he's supposed to do. The part where kids are encouraged to wipe, flush and wash hands is important but I would have been better if they had shown the character do it and not just hear from behind a door.
But, as others have said, it's not really going to teach your child to use the potty. If you're in the middle of potty learning it's good reinforcement, but it won't do it alone (and the second and third episode on the DVD have nothing to do with the potty). Buy it for the fun, not for the potty training.
I, myself, thought the video was cute. My son seemed to really like it at first and has rarely had any fears. He loves the Bear and the moon at the end (which seems freakier to me than the weasels!). The only other thing that ever frightened him was an episode of Sesame Street with a big bad wolf.
When we were watching it for the 4th or 5th time, I noticed a look come over him and he asked me to turn it off. I finally determined the weasel part was frightening him. It gets all dark during this song and they sing about the "cult of the potty" with a Near Eastern tune.
He hasn't watched it since and I have put the box away. He now has very little interest in using the potty (he seemed interested before). I realize this reluctance may have nothing to do with the video scaring him. However, I wish I hadn't bought it.