yeah, there someone still needs to sell the art. I'd imagine it's the artist until you're a massive success.
The only way to insulate yourself from that would be to be completely unsuccessful.
But then you would have to be either extremely poor, which is exhausting, or make/have money another way, which is likely to be a huge distraction.
There is really no solving for this.
A friend of mine has been a professional painter for the last 50-ish years. He makes a couple trips a year to the gallery to deliver paintings. The gallerist tries to take that chance to suggest a few motifs that seem to sell better, but doesn't get too pushy.