Nothing wrong with PERUSING the dream, in fact that is highly recommended before you make a decision.

As far as PURSUING the dream, that's a different story. I hate to say it but the aviation management degree is a bad idea, it has no real value other than punching a ticket. Professional pilots must expect to lose their jobs (more than once) to furlough, bankruptcy, medical problems, etc.

IMO, it is unrealistic to enter this profession without a backup skill. Aviation is not, I say again IS NOT, a reliable means of generating an income. If you are young, single, going to stay that way, and somewhat bohemian it's possible to spend 15 years of your life living in run-down apartments eating top-ramen.

In your case since you have the double whammy of family and poor access to funding I would suggest immediately switching your major to something which has practical employment options. If you still want a crack at aviation someday, select a field which is boring, stable, stable, and portable...accounting, pharmacy, physicians assistant, computer programming, nursing, etc. Graduate, get a job, and keep flying and working on your ratings on the side when you can afford to. Wait for good industry timing before you jump to aviation, and have some money saved up.

If you have the right backup skill, you can work part-time to earn some income and to keep your skill ready on the back burner for when (not if) you need it again.

Thats the only realistic path I see, unless your wife is a doctor...