I think the bot is fine in principle. The YouTube web site is fucking terrible and it’s nice to introduce people who don’t use automatic redirects or 3rd party clients to an alternative.
My problem is that it would offer only piped.video links. We don’t know how long the piped.video instance will work, but well that’s the case for any instance. Ideally a bot would provide at least two links - piped and invidious, and maybe cycle or randomly choose instances. Perhaps under a spoiler tag.
Of course it’s up to community mods to choose, but I think bots like this or the tldr bot provide value even if they can cause that “Reddit moment”.
I like both the piped bot and the tldr bot for the same reason: I don’t need to visit a horribly bloated, ads and scripts ridden web site, which most news sites are. So I take the bot as a really good service. Also consider that without it I’d say most will just read the title and may make conclusions based on that. I’d say that’s a bigger advantage than the downsides you mention.
(Yes I use adblocks and stuff. Most news sites are still a drag to visit and difficult to read.)