Andy Kaufman was definitely weird, but denying that he has talent is a lie.
He was a very skilled bongo drummer, he was very good at acting (after all, that's how he fooled his live audiences, when they couldn't figure out if he's acting or not), and his Elvis-impersonation was the one Elvis himself liked the most, so his singing and dancing must've been pretty gosh darn talented as well.
He was a master of pissing off people, by seemingly mocking them (he wasn't serious, but people fell for it, which also tells of a great talent of acting and fooling people, not breaking character) and doing seemingly crazy things.
BTW, if gender is just a social construction, why wouldn't it be perfectly OK for a man to wrestle women?
In any case, what he did in the way of pissing off feminists and other lunatics, showing off the hypocrisy of their arguments and bringing the old delusion that women can do anything men can do (and better) to the light, was priceless.
No one could've done it better.
However, I think he allowed his weirdness to consume him, and his character(s) that he didn't allow himself to break, eventually sank him - together with the tragic illness.
I think Tony Clifton was a bad idea and a wrong move, but it may have been his only way of blowing off some steam without having to resort to breaking character.
I think that in the end, he was a bit confused, and wasn't sure what he wanted to do - he considered himself a 'song and dance man', but I think that wasn't enough for him, and he tried to get angry and weird reactions out of the audience by being awkward and just doing whatever he wanted.
He remains a bit of a mystery even to this day, but he basically started and cultivated a then 'new' style of humor, that wasn't always funny - I guess he could be said to have been the original troller.
He was extremely talented in many ways, but he didn't use his talent the conventional way, so he ended up not being always very entertaining.