Welcome. Good luck with your pursuit. You have a tremendous amount of research ahead of you and will receive about 560 opinions on this website. However, you will resoundingly hear don't go to Embry-Riddle. I agree. You have a degree already. Airlines do not care what your degree is in, so getting an addition degree in something aviation related is a complete waste of time and money. What you need are your ratings. How to get them....

If you are still open to the US Army, i highly suggest the WOFT program. It is available until age 35, it is for flying exclusively, and you enter as a warrant officer, which has plenty of benefits. The downside is you'll be a rotor pilot, but again, that has pros and cons. I suggest you check it out and research it. It's a good route if you are open to the military.

Strictly civilian, it all depends on how much time and money you have. If you have the money, AllATPs or something similar will the most effective and fastest route. I'm not sure how financial works for that, if at all. I'm pretty certain you'd either need to money or a non-financial aid loan. Less money is to find a flight school close by that has fast track options. Or, you could take your time, say two years, and pay as you go. Lastly, many will suggest buying your own Cessna 152 and simply hiring a flight instructor and selling the airplane later. That's the most cost-effective.