You know, Paramount+ may have cancelled and removed Star Trek: Prodigy, but did Nickelodeon? We'll at least have a chance to record the show off Nickelodeon, and they conceivably could pick it up themselves for a Season 3....
Both are owned by Paramount, though, so I wouldn't get your hopes up, but they are different entities INSIDE Paramount.