If you go into computer science, you will:
* Work with a lot of socially underdeveloped people. Hey, they spend their time fighting compilers, not reaching consensus. Soft skills are largely irrelevant.
* Probably work in one of a very few technology hubs around the world. This is all the more painful when you realize how little interaction you actually need with your team, and you could be doing your job from a shack on a Thai beach.
* Never have your job understood by anyone. Unless your S.O. is also a geek, he/she will have no deep understanding and appreciation of your work, beyond the decent salary. Random strangers will have no idea what "software engineer" or "researcher" means.
* Spend your life in front of a computer. If you are in a certain percentage of the population (which you won't know), you may suffer debilitating physical pain from this which curbs or ends your career.
* Experience a significant uptick in ageism around your mid-thirties. Just when you're gaining some wisdom to go along with your sponge-like learning ability, you'll suddenly find yourself devalued for no objective reason.
You can go into finance and become a millionaire, or at least hob-nob with a few. You can become a doctor, lawyer, or (to a lesser extent) a CPA, probably make better money, and get significantly more respect. You can become a teacher, cop, or join the military and make less, but be labeled 'hero'. Why would you want to be a professional geek?
My advice to young people is to pursue your interest in CS, but major in something else. Being in a non-CS field with outstanding computer skills makes you very special. Those same computer skills are merely so-so in tech centers, and you have no additional versatility.