Lots of non-technical jobs require you to sit at a computer all day. Why do you think they teach typing in school now? The ability to automate your tasks is a superpower that I would love my children to have regardless of what they do. I personally have had jobs that could probably be automated by a python script, although what I was doing them at the time I didn't know how python.
Besides professional reasons, basic programming skills can be the gateway to any number of hobbies. I build things for myself all the time and because it's a creative thing, and programs can be written to aid in creating artwork music, or even to generate these things completely from the software.
Most schools have art and music programs. They may even be a mandatory part of the curriculum. Because we recognize that there are benefits to learning these skills even though the majority of students will not go on to do these things professionally. Programming is the exact same thing.
It's different to make a kid take piano lessons than to force them to practice every day because you've decided their career should be piano virtuoso. I think it's the same with programming, it can be a very useful skill, and there's nothing wrong with wanting to teach it to your kids as long as you don't force them or make them miserable.
In the end, I learned a skill that has given me a lot of enjoyment in my adult life. Personally, the end was worth the means.
Kids spend a lot of time being forced to learn things in school. I didn’t perceive having to practice an instrument each day as worse than having to attend PE class.
Are there counter-examples? As a kid in that sphere I met many other kids who were very good at music. I never met any who hated playing music but I did meet many who were not that interested in the classical music they were playing. Many played other kinds of music in their “free time”.
I’d say it’s fine to teach your kid to be a piano virtuoso, as long as it’s the piano and not (say) the violin or cello, because cello virtuoso is a non-transferable skill, whereas piano can be transferred to whatever genre they eventually end up liking.