I think the issue regarding technical majors versus non-technical one is based on your commissioning source. Based on recent posts in the Military Forum, I believe that right now, if you went to apply for OTS, they won't look at you unless you have a technical degree. One of the reasons for this is that the manning in the developmental engineering career field is less than 50%; therefore, they are doing everything they can to try to attract more engineers to fill those slots. As far as most other career fields, they have most of what they need, and they are filling those shortages through Academy and ROTC graduates. So, the place where technical versus non-technical comes in is if you are applying for OTS.
Now, you said you were going to be trasferring to SDSU with AFROTC? Does that mean that you have two years of ROTC in or are you going to be starting at that point? After your sophomore year, you will receive a slot for pilot, navigator, missileer, technical, non-rated ops, or non-tech; that guarantees you a slot towards a commission (assuming that you maintain the grades, etc). These are all based on the manning requirements of the year you are projected to be commissioned. The only difference a technical degree will make is if you plan on going into the technical career field; all other fields are open to pretty much any degree. That being the case, you will be offered a slot at the time in which you attend Field Training.
So, back to your question: will a technical degree improve your chances for a pilot slot? Probably not. It might improve your chances for a commissioning slot, as the AF is really hurting for engineers.
[But here is my word of advice: you need to watch out; if you enter as an engineer and try to transfer to pilot training, you will need the support of your boss. With the AF hurting for engineers, some bosses will try to talk you out of transferring to pilot training or make it difficult for you so they don't lose you. My advice would be to be up front about your intentions, reassure them that you will remain focused on the here and now mission at hand (engineering), and continue to work hard up until you take off for UPT. I've worked with a lot of engineers, and some made it to UPT and some didn't; this is the way it worked for most who made it.]
Things that will help you get a pilot slot: good grades, strong AFOQT scores, flying experience, and probably most important of all is the commander's recommendation.
In my career, very few of the military pilots I met were engineering majors. In fact, most of them had degrees such as international business, human factors, English, history (I met a LOT of pilots who had history degrees). I also met a pilot who had a degree in music! The only time a technical degree has any issue on a pilot is if you want to become a test pilot; those slots require engineering and physics degrees.
I'd say your best bet would be to remain in your current program with your strengths and high grades. I would go talk to the ROTC detachment at SDSU and tell them you are on your way. You are going to need the support of the PAS there to get a pilot slot, so I would go and introduce myself over there and get their help right now before I transferred over there, and see what advice they have for you.
Good luck!