Yes there will be a market for human artists as much as there is a market for horses to pull things. There are still jobs for horses now, but their number is way lower than just 150 years ago. Not great news if you are a horse (or a human with a job).
Great video from CGP Grey on the topic: https://www.youtube.com/watch?v=7Pq-S557XQU