I'm sorry you missed the shot, but I'm glad you went to see it in person. It's an historic event and it's good to be able to say you were there. I actually only took one or two shots of the second fly over just because I wanted to see the it with my naked eyes rather than through a veiwfinder.
My son and I also decided to go at the last minute too and the challenge for me was that I had left my meter home. Fortunately, I used my son's digital camera to get a reading off of the George Washington Bridge, which I guessed would have a similar value to the shuttle and 747 and made my settings accordingly.
I'm glad I got my shots processed and posted in time to "inspire" you (you might be the very first) :-)