Well, wading in-between the irreconcilable camps of "worst thing I ever saw" and "by Q, isn't this trauma and resolution thing wonderful?" one more time (I doubt any of us will convince the others). Is it a failure? Naturally depends on how we define it. Commercials and numbers are hard to pin down in the streaming era. Whether or not Paramount/CBS/whoever considers it a return on investment is hard to say. But I don't think that's really how Trek fans have ever defined success or failure (let's face it, TOS wasn't considered a success at the time: that took several more years of reruns). We could go by critical response. Google for the reviews of the last episode, and it isn't pretty. IMDB holds some pretty low ratings for the season, certainly compared to other Trek shows. Rotten Tomatoes has a pretty bad audience score. I'm sure hardened defenders will claim some sort of mass skewing of the data by "haters" but that doesn't seem to affect other genre shows with equally devoted fanbases (The Mandalorian seems to have done just fine). Not to mention that even were that skewing true then, well, not a great sign that you've got enough people quite so rabidly mad. But perhaps the best barometer of failure or success, even moreso than audience reaction (which seems far more negative than even Enterprise, which was just getting a solid 'meh, boring') in its darkest hours is this: TOS is being talked about almost 60 years later, TNG 30 years later, and even DS9 and Voyager have their followings and newer fans. Will anybody be watching it in ten years? Will it be inspiring fans, fiction, conventions, people endlessly rewatching as they have the others? A question we'll only know the answer to in time. But I'd bet any money that it's a solid no.