In departing email, Rogers calls on his staff ‘to continue to challenge ill-founded arguments ... and never be afraid to speak the truth to those in power’