No. Your academic major plays a minor role in pilot and combat systems officer selection. You can major in any degree program and compete to receive a pilot or combat systems officer slot in Air Force ROTC. You can even be on an Air Force ROTC scholarship in an engineering or science major and compete on an equal basis for a flying position. Additional information can be found here.