Yes, this video is what you think it is (assuming you're thinking about the time John McCain called his wife that), and it's funny. It also uses the c-word. A lot. Don't worry, there are safeguards to prevent it from entering the mainstream. You'll probably never see it on a daddy blog or something like that.
Here's the story of McCain and his trollop of a wife:
Source: The good people at Scanner