The simple answer for why Ralph garners so much attention is because he is the quintessential lolcow.
He has delusions of grandeur that routinely motivate him to blurt out things like "bitch, I'm an internet celebrity" or scream at the top of his lungs "do you know who I am, whore?!" at a pre-recorded video of a woman who is completely oblivious to his existence and just so happens to be friends with a guy he had an internet slapfight with. Bear in mind this GOTIS level of self importance stems from latching onto a hashtag about video games 8 years ago.
He overshares. His realtime locations, micro-penis, grooming mentally-ill teenage girls and women with equivalent intellect, abuse of his terminally-ill mother etc. are all windows into Ralph's life that he has flung open voluntarily. The funniest ones are where he tries to "correct" what actually happened with something any normal person would be embarrassed by. "...I wasn't eating literal shit, I was just adjusting my sanded-down coke nostrils!"
Okay...?
He is impulsive and over-emotional to the point that he literally invites people to fuck with him. He is quick to point out that there's no such thing as a boundary for a Ralphamale but the second he gets his shit pushed in he flails for the police or the legal system, despite being mired in all manner of bullshit with them.
He's a fat fucking hypocrite. Any time he attempts to take the moral high ground on an issue you can point to several examples where he's done something more egregious.
And the big one is that he simply does not learn. He is going to be embroiled in these conflicts for the rest of his life because as Jim put it, he is a rage pig to his core and will continue to be until his lard-encrusted heart finally gives up.
In other words, he's funny. Just not in the way he thinks he is.