oh, I doubt, to be honest, that I will be able to find this video. I still remember him on YouTube and the scandal that arose around him. Especially how religious and elderly people reacted to this. Therefore, it is logical that it was easier to just delete this video from the map of the earth and everything.
Glad tumblr was brought up because I 100% remember those posts upset about it, and I'm fairly sure I remember the advertisement myself. My only suggestion is to use the wayback machine on MTV's site from back when their version of Scream was coming out. There might be some version of that ad on there. Otherwise I would comb through Google search, I'm sure some news articles talked about the ad in question if they caused such a stir up. Or the ads might even be archived on youtube themselves, as ads tend to have their own channels (albeit not in their skippable forms).
I remember seeing this, looks like there was a similar Spotify ad floating around at the same time. MTV also used Spotify to promote Unfriended with similar results.