It makes no difference on which detachment you go to. That isnt the deciding factor. Its all up to the indivdual student. Probably one of the reasons Embry Riddle does well with pilots is because many of their students have flying hours (as that is a big major there) and many of their students have engineering degrees which AF always likes. My son went to Purdue, also got a degree in Professional Flight (pilot) and in my opinion a way better school than Embry in both flight and engineering as well as being a more collegiate type of school. However, you can be a pilot with a philosphy degree if you have the grades, be an integral part of the detachment, do well on the AFOQT and TBAS test and have flying hours. Find the school and major that works well for the student and if he or she excels at the school, they will excel at ROTC. If you have a crappy experience in college, you wont have a good experience with ROTC. If you have a great experience with ROTC, you will still hate life, if you hate your college.
University of N. Dakota is supposed to have a good flight program and has AFRotc. It is however ND and it is cold. Florida Institue of TEchnology also has a great flight program although it doesnt have AF Rotc. My son was going to go there but chose Purdue instead. Addtionally ARizona State has a good flight program and has AFRotc. That is assuming your son wants a degree in flight. Embry Riddle is a fine school, modern buildings (sterile comes to mind) and not your standard college environment. Its 80% male 20% female so it isnt the best place to socialize. However, to each it own and plenty of people love it there. My younger son's friend went to the one in Arizona and then transferred to the one in Florida. He thrived in the Florida location.
As or my son he got a pilot spot and I think pretty much everyone who wanted one got it. However, this was 2017/2018 and it was way easier then than it is today