Prodigy was probably axed because it didn’t do well enough on Nickelodeon. Hopefully it was a reasonable success on Netflix, but it doesn’t look like there will be any more. It was a good show, but it did lean heavily into the old Voyager characters especially in Season 2, so maybe it’s the kind of thing that appealed to existing fans more than new ones.
It’s obvious that they’re putting all their eggs in Starfleet Academy, so if that doesn’t work out I’m not sure what the next move will be. Maybe they’ll decide that Star Trek just has a dwindling audience and cut the budgets accordingly.