I'm really disappointed by this, but I'm not surprised.
From what I recall, Prodigy was essentially developed as a "loss leader" due to fiat of Kurtzman, who thought Star Trek needed to have something akin to Clone Wars to help bring a new generation of viewers in. But in the end it seems like its audience was just a portion of the existing Trek fandom, and it didn't really convert that many kids.
Not surprised to hear it's being scrubbed from the site - that's the way it goes these days. I am surprised to hear they're still shopping it around though and finishing production since that doesn't seem to jibe with either writing it down as a loss or keeping all Trek IP on Paramount+. Maybe it will be sold for cheap to Netflix or something?
I wonder if it vanishes from streaming entirely it will still be considered part of Trek canon? I mean, that's Paramount essentially erasing it from existing anywhere.