Programming computers isn't magic. Could you write a knitting pattern, with options to customize it for different sizes and shapes of wearer? Same sort of thing. Do you use formulas in Excel? Do you write macros for Excel or Word? Were you happy with algebra at school, 2a + b = 32 means a = 16 - b/2, that sort of thing? And have you the staying power to go through your car's instructions to find out how to reset the clock twice a year ? ;)
But, like, say, law, learning all the stuff you need to know is a lot of work, and you're always having to learn more. Comparable to being a musician who has to get on board with a new instrument or genre every few years.
I was a programmer for over 3 decades (v recently retired) and TBH the vast vast VAST majority of my colleagues had degrees in computing or numerate subjects like physics or chemistry. Though there was one guy who'd come in on a graduate entry scheme who had an English degree...
The only late-entry successful programmer I know - so, a good role model here - was one of our receptionist/administrators. Taking, I assume, the, "if these bozos can do it, how hard can it be?!" view, she did a BSc in Computing with the OU in her own time, did a bit of project management at work meanwhile, and had a successful software engineering career after she graduated.
I do rather think all the "why not learn to code!" and "gurrrrlls in CODING R KEWL" advert writers have 0 idea of what the job actually entails and know 0 programmers. They would never ever go "Why not learn to be a lawyer!" "Law is Cool!" because they have a solicitor mate and know they had to do a fuckton of work to qualify!
I will say that you don't have to be the sort of person who write programs for fun to have a career in it! I liked my work but I don't do it for free and I did just fine.