Warning: if any of you are in a public place and don't want to be seen with a tear in your eye, then save this for later.
Here's a storyboard scene, written by Chris Chibnall, that tells us what finally happened to the Ponds, and to Rory's dad, Brian after the Angels took Manhattan...