Stupidly? If that's what you want to do in life, there's nothing stupid about it. The point is that they don't have room for you. Changing major will do nothing. I don't see the point in changing what you want to do just to get into a college.
Going to a good college doesn't guarantee a good future.