This is not how things get made. If Trek shows are not finding the audience they need to justify how costly they are to make, than they’re simply going to stop producing new Trek shows until some years down the road when a new producer with enough clout wants to revive a familiar property.
You do realize that different shows in the franchise are currently trying to fill different niches and appeal to different audiences, right? Prodigy is far from appealing to the traditional trekkie. It's primarily targeted to young adults and children via Nickelodeon branding. The characters were largely insufferable at the beginning. Yes to show character growth, but this likely also turned people off
Just because one niche show in the franchise wasn't super successful or was too expensive to make does not mean the current generation of development is doomed.
This writers strike has caused production calculus to change. That's likely what started talks at Paramount leading to the current decision amplified by their current financial status.
And just because you didn't like the ending PIC doesn't meant it wasn't immensely enjoyed by others. I would love to see the next next generation on the enterprise G with all the cheese it might entail. I absolutely would eat that series up! Don't worry, I don't need you to be convinced for me to enjoy it 😊