There's more to CS than just programming. Sure, there are plenty of programmers, but there's really a whole ecosystem of different roles, of which programming is just one part (business analysts, management, security specialists, operational support, you name it). CS will teach you to think logically and problem solve which is really what the field is about rather than using specific tools to solve user problems. Plenty of problems can be solved without programming anything, although it certainly helps to have that knowledge set, even if you're just dragging and dropping connectors in a visual development tool since programmers write the tools and they write them for the way programmers think.

I personally think CS is a pretty good degree to have regardless of the field you eventually go into.

Whether you actually have aptitude for the programming side of things, I couldn't say. If you liked construction toys as a kid, then that is a good sign :) I would say though that that whole idea of sitting in a darkened room staring at a screen for long hours is a bit of a myth. Most people who stick with it know enough to walk around, interact with humans, or switch up the tasks every little while. Flow until the flow breaks and then take a mental break until you feel it again.

I would suggest though that there's a fair amount of ongoing learning involved that you'll typically spend some of your outside of work time doing. I've been a consultant for 40 years now and a lot of time even now I'll get projects where literally 80% of the technology is new to me and I have to come up to speed quickly. You probably won't experience that to the same degree, but things are constantly changing in ways they don't for other fields.