Unless it happens a lot but doesn't get any publicity, which seems pretty unlikely as there are too many widely read forums where people it happened to would report it, and too many publications like Ars, Tech Dirt, The Register, Torrent Freak, and many others that would jump on any such story, we must indeed conclude that it is not common.
The important question is not if it is common but rather will it become common?
Discovery is part of Warner, which is currently being run by someone who will kill content for the tax write offs. He killed "Final Space" for a tax write off, cancelling future season and pulling existing seasons from streaming and sale. And last year they killed a movie, "Acme vs. Coyote", that they had completed and scheduled for release because they decided they'd rather write it off.
Because of that right now I would not buy any streaming content from Warner. In the specific case of Discovery it looks like they are just pulling it from other platforms so that it can be exclusive to services they own, like Max and Discovery+.
That probably means it is safe for now to buy Warner owned content through Warner owned platforms, but I'd worry that in the future they will decide to write it off and it will leave their own platforms too.
I can only recall it happening once before on steam, and it was due to malware on the now delisted game.
I've never experienced a car crash, so they can't be common, why should I wear a seatbelt?