Orville is good because its not Star Trek and its written by Star Trek fans. Its clearly Star Trek-inspired but its not hemmed in by it. It can grow, organically.
ST Discovery’s second-biggest problem is that it is hemmed in by canon. Making it a prequel series was a bad idea, ENT had already shown the limitation of that concept and it at least had the excuse of being made during the unfortunate turn of the Millenium prequel craze. With ST DISCO, there was absolutely no reason for it to be set in the past, the entire first season could have just as happily been set a decade and a half post Nemesis, which was real-world elapsed time at the start of production. Hell, even the spore drive could have been seen as a logical extension of the super-fast travel technologies brought back by Voyager, they encountered at least 4 such super fast means of propulsion if memory serves, and the Klingon War, as Korean War to the Dominions Wars WW2. Even the Burnham-Sarek connection could have been explained away as her being Sarek’s ward, a survivor of the Cardassian wars (maybe Setlik III, which O Brien fought in).
Its biggest problem is that it was written by a committee.
Picard, has been treated with derision by some, most notably @RickJay, but I think comparing it to ST DISCO is misplaced, while Discovery is abysmal, Picard is merely disappointing, it has some genuinely good bits, the Troi-Rikers episode, the La Siena crew, the flashbacks. And, unlike DIscovery, who have doubled down, Picard producers seem to have understood fans feedback, its season 2 trailer shows a story in the style of episodes like Tapestry and Encounter at Farpoint, Journeys End.