Most of them seem to have been largely irrelevent throughout their professional life, and this provides a tincture of the attention they apparently craved and never realized in their pre-retirement careers.
Those who did have some prominence saw it fade, and I can see how that might be discomforting. Being one of the later Moon-walkers, for instance, may have been a little disappointing, given that viewing figures (and hence coverage) dropped quite rapidly. Apollo 13 jumped the shark on that show

.
Attention-seeking is very much part of the denier scene. McIntyre, Watts and Monckton rose without trace to suddenly become international denier icons in their later years, and they won't give that up easily. Their more dedicated followers won't desert them even when they pass beyond retirement into emeritus rank or, heaven forfend, death. The dog-days of denial will have a long tail.
The attention given to (for instance) Mann, Hansen and Jones is, ironically enough, a result of attention-seeking deniers calling them out to single-combat. The element of surprise in that strategy wore off long ago, hence the 49'ers and the the WSJ 16 and (gawdelpus) the Oregon Petition.
Will there even be another release of stolen emails? SlimeItGate 3? That shark pretty much got jumped in the pilot, but maybe there'll be something just before the US Presidential Election. Only in desperation, though, after the weird weather over there recently - the last thing Romney's campaign will want to draw attention to is climate change, I'd have thought, and I don't see Obama making it a big issue unless it's a very hot summer.
AGW is a people-watching exercise for me these days, and very entertaining it is.