The ending of the game is Aerith saving the world. The story of Final Fantasy VII isn't the story of Cloud's love life, the story of Final Fantasy VII is about saving the world. Since Aerith saves the world, that makes her the heroine of the game.