A concurring viewpoint:
My son was originally accepted to ERAU Prescott in 2007 as an aeronautical science major. We hammered away at him until he switched his major to aerospace engineering. Good thing, because when he went for his 1st Class Medical prior to leaving for school, a congenital vision issue was discovered that, even after an FAA appeal, prevented him from ever qualifying for the med certificate and becoming a commercial pilot. So he decided that if he couldn’t get into space as the pilot on Virgin Galactic, then he could do it as the engineer. Of course, 8 years later, he’s in a totally different field altogether, but we are all glad that he didn’t limit himself to the commercial pilot program.
St. Louis University also has an aviation science program. Both SLU and ERAU allow non-aviation science students to also take flight thraining through on-campus programs. But at least back then, those programs were must more costly than non-degree flight training.