The right to be forgotten is a simple way to say: "I do not want this content to exist on the Internet". Does that stop the content from existing? No, of course not. Revenge pornography can still be found after that Pinkwhateveritwascalled website got shut down. But it got more difficult, and its a matter of supply and demand. If the website is only accessible via Tor, then those who got the content on their computer took more effort into obtaining the content. You could make the same argument for child pornography.
That being said, the real problem is the lack of prosecution for the content creators. And that is true for child pornography and revenge pornography and bullying videos. However, trend is that the latter 2 are on the rise on the public web. If the right to be forgotten can slow that trend down, I'd say that's a good thing.