Take this with a grain of salt, as I’m just a hobbyist and haven’t done any professional work. But from what I’ve heard from other artists, social media success is not really necessary to be a successful artist unless you want to get all of your work / do all of your advertising from social media. For instance, I know there are a good number of artists who make their money from selling pieces irl rather than online–in that space, being big on social media isn’t gonna be a major boost.
With that said, art is a tough career in general. I know a lot of newer artists who have difficulty finding consistent work. I nevertheless wish you the best of luck!