He's probably a nice person in real life (although I could imagine him being that annoying loud friend), but as a pundit he's truly terrible. He has his schtick of laughing as loud as possible as soon as he's uncomfortable or has made a joke he finds funny, and his level of analysis is piss poor.
I was listening to his interview of Raheem Sterling on the BBC daily podcast earlier this morning - he's talking to a player I think is quite articulate, and the level of his questioning was awful, it was like he hadn't prepared the interview at all. He started by pointing out that City "don't score as many goals as I'm used to seeing so what is it, have you become more defensive minded or what?" And the subsequent questions were basically asking Sterling about his haircut, John Stones's dance moves and whether he should put Sterling as his captain in his fantasy football team.
I don't think you need pristine qualifications to be a decent pundit, but even by those pretty low standards, he's utterly incompetent at his job.