But let's look at what remains more closely. I don't know how they got this show on the air (probably Gene Roddenberry's pedigree) or who they were targeting. Hollywood always targets an audience, at least these days, they do. Young males, young females, older folks, kids. TNG does not seems to target any of these. There's no rogue-ishly handsome lead character breaking all the rules to hunt down bad guys or solve mysteries. There's no earthy lead woman with sizzling relationship drama. There's not even character romantic tension (not much, anyway). It's a show full of rules, discipline, uniforms, and military jargon. They operate in an unfamiliar place in an unfamiliar time. They used Whoopi Goldberg in a completely unorthodox role. Everything about it seems wrong on paper.
But mainly, I wonder who suggested Picard. He is your lead character - who suggested to the rest of the writers and producers that "hey let's make him an old, bald, curmudgeonly French dude!". I'm baffled, but in love.