I have to agree with everyone that says the add is funny. It is so completely tongue-in-cheek I don't see how anybody can find it offensive (unless you don't like girls). But then again tongue in cheek is, by definition, humor in a subtle lack of seriousness.
The point of the add isn't so much as using sex to sell the game, but rather using shock value to sell the game. The adds are meant to be ironic, which makes them eye catching ,and funny. I like them.