Well, if you take the story at face value, his leaving of wife and child occurred at the onset of his spiritual quest and was a manifestation of exactly the kind of misperception we’re talking about here. What prompted him to leave was his profound dissatisfaction with his life as it was, and a search for an alternative reality. But that’s not what he got.
After his awakening he didn’t urge his lay disciples to abandon wives and kids. He specifically instructed them to take their family responsibilities seriously. He gave that advice now knowing that the “householder’s” reality is already perfect, just as it is. This clearly hadn’t been apparent to him at the beginning of his search.
I know a whole lot of Buddhists, but none who think the Buddha advocated abandoning relationships. To the contrary, Buddhism is focused on seeing the relationships that we have previously ignored. Interdependence not independence.
Where relationships get problematic from a Buddhist point of view is when ego gets involved, i.e. when the relationship is about what I get out of it. That kind of relationship invariably disappoints. It’s a lousy basis for a relationship.
I happen to have a dog whom I love very much. It’s a strong relationship, full of joy. But not a day goes by—and I mean that quite literally—that I don’t consider that at some point this dog will do as all my other dear pets have done: he will die. This isn’t some spiritual exercise that I impose on myself; it’s just a little insight that keeps popping up.
Does that insight make me love my dog less, or not care? To the contrary. I knew when I adopted him that it would have this very painful end, and every day I clearly see that this is where it’s all heading, so that each day is infused with the poignancy of that realization. This makes me want him to have the best life possible.
One of the best known Buddhist scriptures, the Metta Sutta, has the Buddha describing this feeling: “Even as a mother protects with her life her child, her only child, so with a boundless heart should one cherish all living beings.”