The climax of the story of El Cid is when Rodrigo Diaz de Vivar, also known as El Cid, wins a decisive victory over the Moors in the Battle of Valencia. This battle highlights El Cid's military prowess and leadership, solidifying his legendary status as a hero in Spanish history.