Yes, it shows Red XIII and his kids. Whiiiiich doesnt really tell ya much. Yes, everything becomes all naturey. But what happens to the rest of the team? There's a big theory going around, or their was before AC was announced, that the humans had been killed by Holy.

Aeris is in it only as a flashback to her (SPOILER)death and other parts of her involvement in the game.