I thought the conversation with Wesley was in Latin.Picard lead a group of children in the song "Frère Jacques" (brother john) and he had a very brief conversation in french with Wesley.
During the episode "Family" I assume that the entire time Picard is with his family in La Barres they're all speaking french.