I have a feeling this specific bit is about Patrick Stewart's past. His dad was abusive. There seemed to be a hint of the same in the flashback.Didn't need the flashback to young Picard.
I would guess that Picard staying single is a protective measure, in some ways to not risk himself doing that to someone he loves.
That is likely the character arc for Picard, in this season.