There is a nice scene in "The Bonding".
"I've always believed that having children
on a starship is a very... questionable
policy. Serving on a starship means...
accepting certain risks, certain dangers...
Did Jeremy Aster make that choice?"
"Death and loss are an integral part of life
everywhere – leaving him on Earth would
not have protected him!"
"No... but the Earth isn't likely to be
ordered to the Neutral Zone , or to repel a
Romulan attack! It was my command which
sent his mother to her death - she
understood her mission and my duty... Will
- Picard and Troi, on the turbolift talking
about how to break the news to Jeremy