He did get to see the next phase of space flight, with the SpaceX launch, the first successful private spaceflights. The future is bright with the expanded private interest in it.
And publicly expressed his disapproval of it. The future may be bright, but I suspect Mr. Armstrong missed the future he would've wanted.
Edit: it was his CBS 60 minutes interview that can be seen here: http://www.cbsnews.com/video/watch/?id=7410538n&tag=cont... see 12:20 mark. (you have to go through 2 commercials, unfortunately)
Edit2: more direct link http://www.youtube.com/watch?v=LbIcqTEuxvw near end (only 1 commercial!, but only less complete excerpt)