When it comes to the claims about his conduct around women it boils down to one word: consent.
Without consent then any sexual behaviour or action towards a woman is harassment, assault or rape. If actresses were promised work in return for sexual favours that is not consent, it is coercion. Whilst things may have been very different in the 60s (and more so in Hollywood) it all boils down to a woman willingly getting involved with someone, not in exchange for anything, not out of obligation, nor out of fear.
Even today we have no idea how many cases of sexual assault or rape go unreported, due to the fear or stigma women feel they might face, they have been violated and may not want to go through reliving the incident in front of police or courts. The fact is most women are harassed on a daily basis and always need to have their guard up, whilst if a woman wears something "provocative" then she is often blamed as she was "asking for it"--rather than addressing the toxic masculinity that makes men think they can act however they want.
Roddenberry got lucky with his name on a franchise that has gone of for as long as it has, but he was a figurehead, he didn't do everything himself, he didn't do it in order to preach of a socialist utopia, he did it for his own legacy and profit.
Whilst there are a lot of primary sources cited in this discussion, we may never know the whole story, with time changing peoples recollections, bribes being made to keep others quiet, others not wanting to bring themselves shame or ridicule (because lets face it, if a woman emerged now with her story of abuse faced at the hands of Roddenberry there are large sways of the fandom who would hound her until her life was miserable), but its safe to say that the man did not practice what he preached and putting him on some untouchable pedestal is a little deluded.