Need help navigating "follow your dreams" vs. "follow the money" dichotomy!

Thank you all for your advice. DH and I have agreed to a moratorium on college admissions and major talk for one year. That should take the pressure off everyone for a while! We have time and hopefully when we get back to this discussion we have a little clearer perspective.