Programming can be art in the way that cooking can be art.

Most of it is in fact NOT art but simply done to solve a problem.

Right on. And similarly, you don't need to learn farming to be able to cook good food, just like you didn't need to know assembly language or machine code to be able to write programs before AI.