The head of Exxon Mobil’s massive exploration and production arm is retiring after more than three decades with the energy giant and will be replaced by a former General Motors executive.