Meet one’s Waterloo

To meet one’s final and most difficult or impossible challenge (Napoleon was defeated at Waterloo).

The team met their Waterloo when they went to the tournament to meet the best team in the country.