Trek Central reporting that Star Trek Prodigy has been cancelled and will be removed from Paramount+ in coming days.
https://startrek.website/post/108995
Trek Central reporting that Star Trek Prodigy has been cancelled and will be removed from Paramount+ in coming days. - Star Trek: Website
Did it end on a cliffhanger and this means the ending is unresolved?
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.