If they were smart they would have continued the series to keep kids interested and then ween them onto the older series. Increase fan base = increase monetization of products.
I too am saddened by the loss of the potential this show had. I loved the colorful animations. Even my husband, who is not a fan of Picard or Discovery, enjoyed Prodigy with surprisingly little criticism (he has a lot of opinions contrary to mine about the nature of the newer generation of Star Trek series).
I am holding hope that maybe they will bring it back at some point or perhaps another production company buys creative rights/licensing (not sure how it works) and revives the series.
Licensing is a no-go. There's no way Paramount would sell any iota of the Star Trek IP for movies or TV shows.
You might not be aware of the fan film fiasco, but essentially back in the day people used to be able to do all kinds of cool things including bringing in Trek alumni actors to play parts in their fan films until a man named Alec Peters went a few steps too far. Initially the main complaint was that he was using the Star Trek IP to essentially launch his own competing studio, but he did some boneheaded things like illegally selling branded Star Trek merch. Guy was literally selling Axanar coffee at one point. He was taken to court and Paramount released an entirely new massively restrictive rule set for any fan project, shutting down those not in compliance.
The only way you're going to get access to this content is through piracy. That's the only universal answer to when studios randomly scrub things off their platforms.
I remember when Netflix just started up and we were fresh off the end of ENT. Doug Drexler and a lot of the crew were trying to see if they could get Paramount to let Netflix do a final s5 for ENT, and it went absolutely nowhere but it was a nice little hype train for a while wishing that I could see the Romulan war.
I don't think it had anything to do with the show itself and was a purely financial move.
Companies across many industries are being told by their investors to cut expenses yesterday and they're abruptly shutting things down, laying people off, etc. Even if they're profitable.