I saw that Hitman: Absolution trailer under embargo a few weeks back and thought it was nasty. When I put it to the producer, feebly, that the slutty nun murder video is "a bit strong, isn't it?", he said: "It's a game trailer, it's designed to get attention."
And attention it got, to the point where depriving it of the oxygen of publicity is not workable. Depriving it of the oxygen of cash money, on the other hand, might be. Not buying a product that has objectionable marketing is one message marketeers will take to heart.
As to the content of the trailer itself, game journalists I admire have already laid out how it is objectionable. Others have written on the ugly backlash against criticism of the trailer, which is just as disturbing and much more significant. Here is one of each kind, if you would like to read them: