The same reasoning with TAS also applies to Phase II and we might not have got TNG had Paramount not decided to turn it into TMP.

And one of the main reasons for the writers going on strike.

My guess is Prodigy was cancelled because not enough of its intended demographic of kids and young teens were watching it.

Paramount probably found that too many of Prodigy’s viewers are adult Trek fans, especially fans old enough to have watched TNG/DS9/VOY back in the 90s and that’s when they decided to pull the plug since they’d rather have adults watching Trek like Lower Decks that’s specifically intended for that demographic.

I also assume Nickelodeon came to the same conclusion and told Paramount they have no further interest in Prodigy.