Brad Pitt's role in Thelma and Louise opposite Geena Davis gave him the chance he needed to succeed in Hollywood