The man behind Jean-Luc Picard aimed for the stars in all his work and made TV nobler for it