Tipped to go as high as the number two overall, the Kentucky QB slipped to 33rd before joining the Titans