Exit marks precipitous fall from power for one of US’s most visible evangelical leaders and ardent Trump supporters, amid claims wife had relationship with business partner