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.
That's what's bizarre about this. Paramount made the show, the next season actually exists in produced form, and they are just going to... not put it on their own service which they control? Like, "according to ourselves this show produced by ourselves which has been bought and paid for and is basically free for us to put on our own service and which we know people want to see isn't something we're interested to show."
I don't even like Prodigy and I'm dumbfounded by this move.