Art has been the most expensive commodity for more than 10 thousand years , I think its safe to assume that wont be changing any time soon.
Making money with art is not only realistic but it can be ludicrous depending what you are doing. Problem is that most people focus so much on artistic skill alone and lose the forest.
Which is why mediocre artists usually end up making much more money than high skilled ones and this feeds the mythology around “the starving artist”.
Earning money is a skill by itself. If you dont have it, yes you will struggle. But is a skill you can learn through practice like so many have done before you. Picasso was a great artist but he was far greater business man. If a 90 year old lady that started painting in her 80s out of boredom can make money in millions of dollars I think we can safely assume that art can be quite profitable.
But yes, if you want to become rich, being an artist is the most well proven way to do it. But life comes with no guarantees , its a never ending journey of learning and discovery.