"To wear out your welcome" means to stay somewhere more than you are welcome to stay - to stay longer than your hosts would like you to, to become unwanted. In your case it means to me people do not want to see him.
But I suppose you could find that in dictionaries...
—Idiom
10. wear out one's welcome, to make one's visits so frequent or of such long duration that they become offensive: Your cousins have long since worn out their welcome.