He never wanted to be the last man on the moon, and he almost certainly won’t be, but it’s a shame that he didn’t live to see the next man (or woman) kick up the regolith.
But he didn’t cover himself in glory, or make it more likely to happen, when he testified in ignorance against private spaceflight back in 2010 (the headline of the story is incorrect; they weren’t “defending spaceflight” — they were unwittingly attacking it). He was a hero of the Cold War, and should be honored for that, but his passing shouldn’t be an excuse for a new bout of misguided Apolloism from conservatives.
[Update a while later]
“It appears we are condemned to forego the human exploration of the solar system until the full measure of the first generation of space explorers has passed.” It didn’t have to be, and some of that generation, including Cernan (and Walt Cunningham), didn’t help.