Positioned a bit harshly, but I don't have a problem with the basic sentiment. For as long as you're responsible for them, I don't think you have a responsibility to let them "chase their dreams" in every case. I wouldn't let my kids develop diabetes because their passion was Doritos and their dream was become a professional eating contestant. There are plenty of ways to pursue your passion without spending six figures on a college degree.
I suppose the thoughts on this will have a lot to do with:
a. Whether you have enough money that $200k doesn't mean anything to you, combined with additional support after college
b. Whether you personally experienced being poor, having student loans and having a useless degree
If you've lived the second one, like I have and my wife has, and spent 25 years regretting our "passion" majors, that's going to have an influence. The parents who told us "You're special, you're definitely the one who will make it!" and "Don't worry about it, you're so smart you'll find a good job as long as you have a degree" did us ZERO favors. So we won't be doing that with our kids. The follow your dreams thing is fine for 8 year olds..18 year olds don't need it sugarcoated.
And I'm not opposed to them chasing their dreams. If they want to be an actor, if they want to move to LA and wait tables and share an apartment with six people to see if they can make it, I'm cool with that. When my daughter was talking about that as a teenager, I told her I'd take her out there and we'd check out places when she graduates. But we're not spending a quarter million dollars on a degree in Improvisational Theory as the first step.