I didn't start learning to code until I was 27. I think probably the most compelling reason to teach your kids to code is so that you can work on projects with them and have that shared interest.
But, of course, that could backfire. My dad was interested in antiques, opera, gothic architecture, etc and tried to force that down my throat. I couldn't stand it and that made me rebel hard against it.
Your kids might just want to be different people than their parents, or maybe they really are interested in the things you're interested. I don't know. I say try to expose them to a bunch of different things, not just what you like. Maybe they'll make great software engineers, or maybe they want to become marketeers or lawyers or designers. If you encourage good social, communication, and learning skills, they'll be successful in whatever career path most interests them.
Sorry, I get a little uppity when people start talking about teaching kids to code.