This is where I channel my inner curmudgeon and point out that this whole fannish obsession with "canon" is a relatively modern phenomenon. When I was a kid, I didn't fret over whether the latest DARK SHADOWS or GET SMART tie-in novel was "canon" or not, or worry about whether the Gold Key TARZAN comics were consistent with the various books, movies, and TV shows. Hell, we didn't even know the word "canon" back then, let alone care about it.
Yeah, I'd notice if the tie-ins got things wrong and had Barnabas acting out of character or whatever, but that's a different type of consistency than insisting that every story published in every medium all line up in some sort of seamless continuity. As long as Tarzan acted like Tarzan, I was happy. In my experience, it's all about getting the voice right. Few things seem to bother tie-in readers more than if the characters don't sound like themselves. "Riker wouldn't say that!"
I can only speak for myself but I don't want or expect every piece of fiction ever written in the Star Trek universe to be a seamless whole. I draw the line at the tv shows and movies all being part of the same "reality". It's too much effort to attach other media to the filmed, cartoon or otherwise, franchise given how much literature is out there.
I did enjoy a series of books in the 90's that told a continuous story that began in TOS, continued into TNG and DS9 and concluded with Voyager but I think it would be unrealistic to expect authors to fact check with each other in case they contradict each others stories. It would also be unrealistic to expect every Star Trek fan to read every single book or comic in case they miss out on something.
It's fair to say unless a book is adapted into an episode or movie that novels and comics are a law unto themselves and not required reading*. Come to think of it many of the filmed episodes aren't required viewing either but it's a lot easier to watch every episode of every Star Trek series than to track down and read every novel or comic. It would also be unrealistic to expect viewers to know what happened in the latest novel because the latest episode is a continuation of it.
I love many of the comics and novels but I don't consider any of them to matter to the on screen canon. They're just a really great way to get more material from Star Trek that delves deeper into the plots and characters than you could expect in a tv show or movie. I wouldn't be against some of the novels being adapted to the screen in fact. Paul Dini adapted his comic about Harley Quinn into an episode of the classic 90's Batman cartoon and it was one of the best episodes.
* I do know you have to check your facts in case you contradict anything that happened on screen but that doesn't appear to have limited you given how successful and prolific you've been with your novels
