There are professional artists, and professional illustrators. And it's possible to be both. But despite being two separate job descriptions, they both can make money and be considered professionals.
Granted, when talking RPGs, you're probably more likely dealing with illustration.