Realistically, it's a very low number of people where social media is a driving force to generate the majority of their income. It's an essential part of self promotion (just in the same way someone you might court for business might check your instagram feed for example), but I think the pressure to "perform" on social media, to me at least, feels over emphasized in the minds of aspiring artists. The distance I'm keeping with social media is that I post stuff about once a week and beyond responding to comment, I check it every 3-4 days.
Just being very transparent about my own ambitions, I'm aiming to transition to doing mostly illustration and design over the next few years to try and replace my current income. I do a lot of web based interface design and graphic design for my current career, and I'll be the first to admit that most of it is "work", but there are projects I do throughout the year I feel REALLY good about, get passionate about, love the way it turns out, etc. and I think illustration will be no different - there will be plenty of projects that are just work, plain and simple. And then you'll get projects you are inspired to do and feel lucky to be a part of it. To only do passion projects, I feel about myself, is unrealistic just based on my own journey building my current company.
I do think it's going to take 5-7 years to fully move over because it took at least 5 years to build my existing business and have enough referral business combined with existing repeat business to make a good living.
I think you might benefit from some of the stuff that Marco Bucci talks about on his YouTube channel about inspiration. I think he has a book out that talks about it as well.
Just some thoughts from a newbie - take it with a grain of salt 🙂