Ten years from now, there will still be both human programmers and people who don't understand why they are needed. (I'd make a case as to why that is, but I'm replying to a comment that just states the opposite without explaining why, so I don't feel the need to.)
Programming by humans will become a handicraft, something people indulge in in their spare time because it's "retro" or interesting or whatever. Like knitting or weaving by hand, or programming in BASIC on a C64. I mean to use the "computer" example again, people still do arithmetic by hand, and even learn tricks to better do it in their head.
But no serious software will be written by humans in ten years. It will not be a profession.