I think you're getting confused. Steam (as in the stuff stored on Valve's servers and not in the client directly) does not activate your game on third part activation systems. The client part of Steam (as in the bit on your PC) runs an installation script that contacts the activation system with the required information just the same as an installation script on a retail based game.
Erm yes which is the same as saying "does the installation and authentification for you" which is what I said. How does that make me confused? You're simply repeating what I said but replaced "Steam" with "Steam client" which is semantics - the Steam client gets its info from the Steam servers including your cd key.
If Steam went kaputt and the need to authenticate via Steams authentication server were removed, that very same installation script would still supply the CD key to the third part activation system much in the same way that you can keep manually inserting the key for a retail run installation script (and even some of those now automatically send the key).
And the inevitable question then would be: how would you activate the installation script by hand? (although I'm not even convinced this script is stored locally in the first place) I mean, the activation is originally part of the installation program which you don't have. Steam replaces part of that program but you'd still need to be able to manually activate that script. If you know of a way to do that, please tell me since it's useful to know but I kinda doubt it's as simple as you make it sound.
And if you ever need your CD key for a Steam based game, you can either use the right click context menu to view that information, get it from the text file it's stored in, or get it from your registry, or from the handy little pop-up display that shows it every time you run a game -- until you tell it not to. Or any combination of the above depending on the game in question.
As long as your client will still run after Steam goes down, no problem - but registry settings and all such stuff is not going to be an easy option for most gamers regardless. It would mean that you would need to mimic whatever Steam did during "installation" of the game and that can be tricky.
Anyway, we're sidetracking. My original point was simply this: the whole situation would not that simple (as this argument has more than proven) and the Steam crusaders can't simply state that they'll "fix it" when Steam goes down since it would mean a lot of issues to solve.