Have you run the NPC for your schools? If the dream school is indeed $30,000 a year beyond your means, forget about it. There is no school worth $120,000 of anyone’s debt. I would not let my child put me into that kind of debt and I would not let my child take on that kind of debt for undergraduate education.
When my child was looking at colleges, she may have had dream schools that I inadvertently nixed because if I saw a net cost to me that was more than I could afford, I told her the school was off her list. In the end, she applied to one unaffordable (and it was more affordable than your dream school) school with the caveat that if FA came back with too high a cost, it was off the table. Sure enough, the net cost to us was about $15,000 beyond our limit. She was fine with that outcome because she knew what to expect.
So what do you do? Well, there are probably colleges that fall between “local, last choice” and “dream school”. Go look for them.