Here's a good way to learn more about colleges, majors, and the many paths that can lead to being successful.
Pick five people who are doing something you find interesting–writing, video game design, sports management, whatever. If you don't know or can't think of specific people, pick a company that does something interesting to you, visit their website, and find the names of five people who seem to be doing important jobs there.
Then find out how they got there.
Read their bios. Google them and find out where they went to college, what they majored in, and what jobs they had before they got here. Connect the dots from where they started and where they are now.
I think you'll find two things:
1. The line is very rarely straight.
Most successful people didn't create a scripted 10-year plan to get there. They got there by working hard and making the most of opportunities that presented themselves along the way. If you're struggling to name your intended major or career, you might find it encouraging to see successful people who could never have predicted at age 18 what they would eventually do with their lives.
2. There isn't a lot of correlation between how successful they are and the relative prestige of their colleges.