He had an optimistic vision of the future in which humanity moved beyond its flawed past to explore the stars. Though his personal politics are controversial, his series is an influential part of American culture.
While he create the series, he never had as much control over content as he might have liked. Perhaps in an attempt to gain the influence he sought, he made the rule of "It ain't canon unless I say it is." This has had the unfortunate side affect of sidelining some well written and carefully plotted secondary works.