Strange New Worlds was well received.
Lower Decks has been well received.
Discovery has...at least gotten better each season. It feels like they're trying to improve.
Picard s2 and 3 were shot at the same time, with 3 being announced as the end. Its effectively cancelled just framing it otherwise.
Hardcore fans will watch somehing even if its bad, hoping eventually it'll be good. Its why studios farm these IP's in the first place. Even if its crap it'll still do decently well due to sheer momentum.