Passenger groups, unions and opposition MPs have expressed outrage at the decision to award Network Rail's boss a CBE.