I've only seen him on convention stages, and while I've been to a convention since Gene died, I haven't since Majel died. My impression was that he was just a guy sent out to talk to convention audiences about new projects.
As to the situation that existed during his era, though, we must consider Gene Roddenberry's point of view:
At the time, there were TOS theatrical films being produced, and TNG was still in production, as an open-ended series, with plans to eventually promote or retire Picard, and make Riker the captain. ST books were being written and published at a rate of one or two per month, but ST was still first, last, and always a television series. In addition, quality on TAS was spotty at best, and there were more than a few episodes that made the worst of the third season of TOS seem like Shakespeare. In general, it was (and is) far easier on the TNG screenwriters to ignore TAS and all of the novels and short stories, than to potentially set up a "tail wagging the dog" situation.
Then, too, even though there were a few really good novels of that era that were, nonetheless, shameless Mary-Sues (think Diane Carey) and hardcore-Libertarian political screeds (again, think Diane Carey), allowing that sort of thing to continue would have only encouraged publication of the other 99% of Mary-Sues.
As to the situation that existed during his era, though, we must consider Gene Roddenberry's point of view:
At the time, there were TOS theatrical films being produced, and TNG was still in production, as an open-ended series, with plans to eventually promote or retire Picard, and make Riker the captain. ST books were being written and published at a rate of one or two per month, but ST was still first, last, and always a television series. In addition, quality on TAS was spotty at best, and there were more than a few episodes that made the worst of the third season of TOS seem like Shakespeare. In general, it was (and is) far easier on the TNG screenwriters to ignore TAS and all of the novels and short stories, than to potentially set up a "tail wagging the dog" situation.
Then, too, even though there were a few really good novels of that era that were, nonetheless, shameless Mary-Sues (think Diane Carey) and hardcore-Libertarian political screeds (again, think Diane Carey), allowing that sort of thing to continue would have only encouraged publication of the other 99% of Mary-Sues.