Trek Central reporting that Star Trek Prodigy has been cancelled and will be removed from Paramount+ in coming days.

Sort of - the mystery of what happened to Chakotay is unresolved, but the crew got a more-or-less happy ending. From how it's being reported, season 2 is all but complete and they just need to find a new network or service to show it - I'd wager Prime Video might be a possible home for it as they've historically had distibution rights for the various other modern Trek shows internationally.