Here's a truth-bomb:
You don't need to go to college to be a published novelist. And if you DO go to college, most of the time it doesn't matter where you went to college or what your degree is in or what grades you got, nobody in publishing is checking your transcripts.
I personally know some published writers who didn't go at all or didn't graduate, and some who went to college for something totally random, and some who have advanced degrees like MFAs in writing or even PhDs, and all of them have a similar level of success.
So why go to college at all?
-- If you want to be a FICTION writer, it's helpful to know lots of interesting things and live an interesting life. It's not vital that you go to college to achieve that, but it can be a decent place to start.
-- Using your brain A LOT and reading A LOT and writing A LOT (and being able to do those things on a deadline) are all vital skills for an author. Again, you don't have to go to college to do those things, but it doesn't hurt!
-- A degree in any liberal arts major (English, of course, but also Communications or Journalism or Theatre or History whatever interests you) will force you to do a lot of writing and reading and critical thinking, which is helpful for developing those skills, especially if they don't come naturally to you or it's been awhile.
-- A degree in ANY major will likely help you get a better (non-writing) JOB, and unless you are independently wealthy, it's good to have a job that pays relatively well since writing usually doesn't, especially in the beginning!
-- And going to college can be helpful for learning "soft skills" that will come in handy in publishing, like professional communication, how to get and give critique, getting along with lots of different kinds of people, etc. Again, you CAN get those skills in other ways, but college is how many people gain them.
OK, but wait, go back, you said "most of the time" college doesn't matter... so are there exceptions? (of course there are exceptions):
-- I said Novelist above. If you want to be a NON-FICTION writer, a degree (especially an advanced degree) in your field of interest will give you more expertise and credibility. Like, you are writing a book about immunology or whatever? Probably not a bad idea to have a degree in that or at least an adjacent subject, because a book about immunology by a doctor or research scientist or even a journalist with some kind of scientific knowledge is more likely to be published than a book about immunology by Joe Schmo who mans the hot-dog oven at the Circle K.
-- I said "it doesn't matter where you go to school" above. However. For SOME kinds of highly literary fiction, it can be helpful to go to a prestigious writers program like the Iowa Writer's Workshop. Not imperative, but... I won't say that it couldn't help, just in terms of networking with probably award-winning authors, etc.
-- I said it doesn't matter if you have a degree above, and THAT'S TRUE. However, part of "geting a better job" MAY require graduate school. For example, if you want to be a lawyer, you'll need to go to Law School. You probably DO need at least a Masters/MFA to teach at an accredited college, and a PhD to be a tenure-track professor. So while you don't need any degree to BE A WRITER, some of the adjacent careers that a lot of writers might want to do WOULD, of course, require a degree.
So what should you major in?
-- If you have a career goal besides writer, or your goal is to get into graduate school, major in whatever is helpful for THAT. (So that could be liberal arts or a science field or business or whatever will be most useful).
-- If you don't have a particular career goal and you aren't planning to get an advanced degree beyond a Bachelors, a major in any liberal arts field that interests you will be helpful in your writer life.
-- Regardless: For a BA degree, your mission should be to get through it as fast as you can with as little debt as you can. The "get through it fast" is important because obviously being done sooner is better than being done later and the longer you are in school the more debt you will likely accrue, but ALSO because if you are going to turn around and go to grad school after, THAT's the important part.
-- If your goal is to MAKE MONEY and you don't want to go through law school or medical school or be a tech bro or whatever: GO TO TRADE SCHOOL. For real. I don't know about other countries, but the US has a real lack of folks who have tangible skills, and we NEED THEM. AI can't fix people's dishwashers. AI can't mend power lines or solve plumbing conundrums or build things. If you can be a skilled electrician, plumber, contractor or anything of that nature, you can make A LOT of money and never be out of work, and that security can go a long way toward pursuing passion projects. My favorite teacher in high school gave me this advice, and I was a snob and didn't listen to him. Now I have a billion dollars in student loans I'll be paying off until I'm 60, and no skills aside from reading and writing. DANG IT.