Computer science is an awesome field, I fell in love with it as soon as I made my first html object spin using css. It has several benefits, both professional and personal. It's especially helped me to think about things more analytically in all aspects of my life. Boolean logic has also saved my ass more than once. Is it worth pursuing? In my opinion, absolutely!
Getting a job using your degree will be a struggle, and there are many reasons for this. Some of it has to due with turmoil over AI, but it's not the main factor. Software development will not go away, but it's possible that it will change. Imo, if you want job security, study CS with an emphasis on cyber security. The AI slop apps being created now will produce decades of tech debt and vulnerabilities.
Study whatever you want, college isn't a trade school. Looking at college that way will lead to disappointment, for many reasons. Study the things that interest you, and explore the other fields as well! Sociology, theology, art, graphic design, history, biology, and others all have their applications outside of working. College is meant to make you grow as a person, not become a wage slave.