Yes it has, first of all we shouldn’t consider animated shows to be relevant to the franchise’s success. Pro and LD is nice at times but mostly a bonus for the time, there is no new live action Trek available.Has Star Trek as a franchise been in danger since 2017?
As for the remaining 3 live action tv shows:
Disco was a financial and artistic disaster. The vast majority of viewers consider Disco to be a failed project.
SNW is promising in its very own contained timeframe. It is somewhat a reboot of TOS, has an episodic style. But it can’t shape Star Trek’s future because its setting is just too repetitive.
Picard S1 and S2 were deeply flawed and also not a success when it comes to audience numbers and reviews. Picard S3 overthrew everything (even SNW) and made a bold and demanding statement as how future Trek Tv could look like. And the audience agrees, in numbers and in reviews. This should make the execs of CBS think and reconsider their next steps. It’s also a heavy blow for Kurtzman that the only iteration of Trek which really is considered to be successful is the one, which separates itself most from the showrunners initial vision…