I think it was always going to end terribly (hence why I wanted him to get the Villa job).
Some of these pundits talk a good game and then go into management and realise its a different ball game.
Neville for example, talks brilliantly as a pundit and I can listen to him for ages before getting bored, I was shocked to see him not give it a better go as a manager but it was a difficult job.
Henry on the other hand, I don't even find him an interesting pundit, he seems to just talk about the obvious and I had no confidence that he would be successful as a manager.