As Carol said, think of how much technology has shaped your life. Computers are so ubiquitous that it's easy to forget about them and overlook them. These days, there are computers in our car keys, our washing machines, for some of us our light bulbs, in the games we play, plus they run the grid that brings electricity to all of this. And so on.
But the thing about computers is, they can't do anything on their own. They all require people to program them. One path to becoming such a programmer is to study Computer Science in college (there are others ways, from teaching yourself to coding boot camps, but if you're already in college it's likely that the major is the most accessible method for you right now.) Computer Science is in very high demand, because we keep finding new things to put computers in, and keep upgrading the computers we're putting into things, to say nothing of the enormous number of pure software companies employing people to write programs to run on general-purpose computers (desktops, phones, servers over the Web, and so on).
So, it is very, very relevant. It's hard to compare to other majors because all have their niche, areas of the world where they are particularly relevant. But with computer science, you can find a place to be relevant pretty much anywhere there is electricity, and even places where it's sporadic. Computer science also works well with a lot of other majors. If you like Physics, you can find relevance helping to program the simulations used to test theories. If you like Sociology, you can set up studies and tools using their principles to put their ideas into use. If you like music, you can write programs that help compose new pieces, help musicians learn and practice, and so on.
People have been talking for a while about that idea that sooner or later, computers will be able to program themselves and that will make computer science irrelevant. While Machine Learning has become an exciting new field, and in a few specific areas has been able to help programs do better than humans had ever been able to program them (such as Google and DeepMind's AlphaGo), humans who knew computer science still have to set up the models that allow Machine Learning systems to learn at all. So it doesn't look like this is likely to cause irrelevance any time soon.
Finally, a note on terminology. Technically, "Computer Science" is an advanced branch of math, which people usually only study in graduate-level courses. It can be esoteric and may be less relevant in a lot of ways. However, I'm assuming that you are getting an undergraduate Computer Science degree. This tends to involve more Software Engineering (and you may even have a class or two called that), which is the actual profession you would be going into that I was describing. It's mostly just a quirk of history that we call the undergraduate degree "Computer Science" rather than "Software Engineering", so don't worry that you're in the wrong major on that regard.
I hope this helps give perspective!