I have a different view.
I'm a 1989 graduate from ERAU with a B.S. in Aeronautical Science. I was a CFI before I went the ERAU do only did one flight course at the school, on the completion of which, I received credit for all of the flight courses. I have been employed as an airline pilot since 1990.
Any degree will meet the degree requirement, whether it's a hard requirement or soft. Technical degrees, such as anything STEM, are even better. Aviation degrees show commitment to the profession and the likelihood of above-average knowledge in the field. Any B.S. degree checks the box, STEM and aviation degrees are a plus.
Where my view differs is in the recommendation to have a degree in something else as a backup. A STEM, accounting, business, etc. degree will get you an entry level job when you leave school and hit the job market. Ten or twenty years later, at best, it'll get you the entry level job, where your co-workers are a decade or two younger and more current on the subject matter. In reality, your training will be out of date and much will have faded from your memory. You will have to put significant effort into relearning and updating your knowledge to compete for those entry-level jobs.
My aviation degree has been helpful to me throughout my career because of the aviation related information I learned that those with other degrees did not. When pilot recruiters saw my ERAU degree, they knew what they were getting from an education standpoint. At every airline interview I had, someone on the recruitment team was an ERAU alum. In every airline ground school my education gave me a head start that those without an aviation degree didn't have.
If you change careers mid-life, you'll still have a college degree which will still "check the box" for many jobs. You can build off of it and add courses in whatever new course you choose to pursue. If you stay in aviation, no education will serve you better than an aviation degree. What you learn will be information that you will use for your entire career.
My biggest recommendation for you is to stay out of debt.