Self-esteem is a tricky thing. Sometimes I think we'd be better as a culture if we didn't value it so much. In any case though, lifting weights and other forms of intense exercise are pretty life-affirming activities that I suggest you try a few times just to see what you're missing.
Mainly, because I very distinctly got the sense that you didn't read the article, but I find the idea that people who lift are doing so to ameliorate some other inadequacy that they feel.
I don't "lift" in the traditional sense, but as someone whose close circle of friends has recently undertaken a workout mantra, I'll share with you that the number one motivation is "to live longer".
There's something satisfying about pushing your limits in all areas of life. I hope you reconsider your viewpoint and give fitness an honest try. It doesn't need to be about vanity, though that is a common trap that people fall into.