One of the gripes I had with season one of TNG was this little exchange, right out of the gate, in Encounter at Farpoint
Encounter at Farpoint wrote:
PICARD: One further thing. A special favour.
RIKER: Anything, sir.
PICARD: Using the same kind of strength you showed with Captain DeSoto, I would appreciate it if you can keep me from making an ass of myself with children.
PICARD: I'm not a family man, Riker, and yet, Starfleet has given me a ship with children aboard.
RIKER: Yes, sir.
PICARD: And I don't feel comfortable with children. But, since a captain needs an image of geniality, you're to see that's what I project.
RIKER: Aye, sir.
PICARD: Welcome to the Enterprise, Commander Riker.
Picard's attitude seemed incongruous to me. You'd think Starfleet would have chosen someone to captain the Enterprise
who was not so overtly uncomfortable with children, especially if the ship was really going out into deep space for over a decade.