Yes, it raises the whole question of why some have children to begin with and why it's so important to them. Personally, I think children are their own souls and if they return to spend time with you after they're grown then that's a bonus. Obligatory visits and 'duty' to me are things that are sad and quite the miss the point of true love.

With regard to ghosts as projections of the Unconscious mind, you're reminding me of the way some try to demythologize visits from the dead or see them as unnatural. For example, the Ghost of Hamlet Sr. whom some believe was a demon, a familiar spirit intent on luring Hamlet to his destruction. If we listened to the materialists, there would be no literature worth reading. I think we all know the spirit of a person persists long after they're dead and often will visit us in dreams which seems quite natural until we awaken and dismiss it with our common sense.