Google (and reddit) deals with tons and tons of those requests every day. Now, more than likely, Archive.org would be the one to remove it but that wouldn’t prevent whoever is contracted with the rights holder from sending it to hosting providers that link to it as well (after they find said link indexed in a search engine).