There's a lengthy fanfic series (I know, I know) where in large part thanks to Kataan, Picard acknowledges that friendships and relationships with people are important to a life well lived, and additionally, that he does want to be a father. He eventually marries Deanna Troi and they have a lot of kids.