A disaster of a show
Jean-Luc is too radically different from the dynamic and strong character we knew in TNG. Here he is crippled with self-doubt, lacks essential vitality, doesn’t command respect, is scorned by many characters and treated not as the heroic former captain of star fleets flagship but is distrusted at best treated with outright hostility at worst.
Compare him to Scotty or Kirk in later eras; they recognized that times had changed but they were true to their essential natures. Kirk didn’t become Ensign Barclay, Scotty vigorously pushed back against La Forge’s obvious jealousy of the formers legendary engineering prowess.
This is beyond dismantling the hero archetype but transforming him into a drug addict who steals to assuage his insatiable thirst and scrambles in an alley way, pulling up a urine soaked pant leg to find a new vein to inject into. It’s too big of a transformation to retain any sense of integrity to the character.
As for the plot itself - the androids at the end of season 1 spend an inordinate amount of time working to destroy all organic life in the galaxy but Picards rousing two minute oratory is enough to save organic life from oblivion. Who then dies and an interloper in the form of a clone takes over, with the jarring name of “a Gollum”. It is a ridiculous and an unnecessary outcome which adds nothing to the show.
TOS and TNG had superb writers. Giants in science fiction. The writing on this show has left it a pale shadow compared to the majesty of the TOS-TNG-DS9 era. Even STE shines with brilliance compared to this dross.