The clearest example of his contradictory nature is the original pilot.
That Number One was a woman was important to him, and he fought (but lost) on the issue.
But also she was played by Marjel Barret, also known as his wife.
Roddenberry is like most men who fancy themselves enlightened for their time: his ideals did lead to some good outcomes and motivate him to do things that contributed to better outcomes in history.
He also routinely, indeed more often than not, lacked the courage of his convictions and fell prey to some form or another of the vices any wealthy and influential man may acquire.
There’s Little value in deifying or demonizing a dead man. Instead, understand his role in history with all its complexity, and learn from both his vices and virtues. See the patterns such men follow, and spot where others in similar positions might make similar mistakes. And of course where better decisions could cause them to have even greater impact.