The original story they pitched to Sir Patrick and the one that made him agree to do the show wasn’t even the one they ended up with, at least not for the first season. (I think Sir Patrick mentioned the only thing that remained was the story element about the Romulan refugees.) For the second season we had Akiva Goldsman and his weird obsession with explaining why JLP had never settled down even though TNG had a literal episode (that everybody seemed to have “forgotten” all of a sudden) where JLP had a wife and two kids and had settled down pretty well after some adjustment. (It was not exactly real, yes, I know, but it was real to HIM, that’s all that matters.) It was a completely unnecessary detail to explore for an entire season. No wonder people weren’t exactly interested. They WERE interested in Q’s return, however, and in some more legendary P/Q bickering… and then got like two or three big scenes with JLP in ten whole episodes and that was it. THIS is what they should have been focusing on, especially after they spent months hyping things up and talking about how important Q was to JLP’s life.
In essence, there were a lot of stories. A lot of ideas that muddled things. From everyone. The studio interfered as well. There was a pandemic going on. And in the midst of all this were the fans who stubbornly kept expecting TNG season 8 and wanted nostalgia despite everybody saying right from the start that it wasn’t going to be that.
It’s no wonder things turned out to be as chaotic as they did. There was a massive discrepancy between expectations and actual results.