I mean, hell, even Star Wars, which had the explicit marketing label of "Legends" for the stuff published prior to the Disney buyout, has stayed to Disney's canon, not producing any further works set in that timeline. That is a franchise that outright HAS the "slap a subtitle on it to say it's not connected to what's being put on screen" label, and they STILL don't do that.
(And yes, I'm aware that these are different franchises and publishers, but my point is that this is a similar situation and it's not getting that happening.)
The novels are always meant to be tie-ins to what has been put on screen. On screen Trek now outright contradicts the ongoing novelverse, going back years. That happens, it's ALWAYS going to be the tie-ins that end up getting told to wrap it up - the people on this board are NOT a reflection of the audience at large. We're maybe 1% of it, being generous. Sure, I think most of us would be happy with a label distinction and putting both timelines on the same shelf. But on average, if a person is picking up a book at random, they're going to expect it to feature the characters that feature from the shows, on the ships from the shows, in the time of the shows.
I mean, there's a reason that, historically, the novels set during the TOS five year mission tend to be big sellers. The ongoing novelverse may have been selling well, but at this point, with what Picard and Lower Decks have established about the 24th century following Nemesis, they no longer tie in to canon. We're fortunate to have gotten Coda. The novelverse continuing on despite canon was NEVER an option.