Does cloud ever get to see aerith again

Yes. Both at the end of the game when she appears to everyone above Midgar, and at the end of the sequel movie when she and Zack appear to wish him well, as they return to their place in the cycle of souls around the planet.