Ironically, the appeal is similar to LGBT representation in media. Society tells you that being a certain way is wrong, but you find a person/character who reflects these traits and succeeds despite that, so you cling to them and live vicariously through them. No one watches Asmongold and thinks, "Hey, he's ugly, unsocial, argumentative, and still got rich! That means nothing's holding me back, so I'll chase my dreams too." They watch him for a warm, opioid-like high of validation. It's like animals licking one another's wounds.
For anyone like that, I recommend reading. It can give you some escapism and help your loneliness, but it'll also clear your mind and help you think through your problems too.