Most students coming out of high school are not getting highly specialized college degrees. Most of them do not even know what they want to study.
Most colleges, big or small, will offer the majority of students a degree that you can get at most colleges across the country.
And yes, sometimes it does mean dropping the dream.
If your dream is going to cost you $200,000 to achieve but when you get out of college you are only making $40,000 a year, you might want to look at a different dream.