First of all it is an allusion to Alfred's previous story: When Bruce was away for many years during the events of Batman Begins (when he was an outlaw and later trained by the League of Shadows), Alfred was every years on vacation in that restaurant and hoped for seeing Bruce sitting there happily. He just hoped that he would finally have found a way to escape all the sorrow that Gotham meant for him.
As we learn in one of the ending scenes the autopilot has been secretely repaired by Bruce a long time ago, which already suggests that there was something going on with the Bat. So Bruce really got out of it alive. And this is in line with the movie's earlier motive of Bruce rediscovering his will to live (think of the pit scene as a good example). After all his sorrows and secretely hoping to die for the sake of Gotham he finally managed to find back to himself and dicovered that there could be a Bruce Wayne without a Batman. He managed the "symbol" to bring the ultimate sacrifice for Gotham and remain in the minds of the people forever, while still not sacrificing the "person" and found a way to finally seperate Batman from Bruce Wayne.
And this leaving behind of Gotham and all its sorrows is what Alfred always hoped for Bruce and in this last scene he (and the audience) finally found it. So what Christopher Nolan gave there was not only a happy ending for Alfred (and the audience) but the culmination of Bruce's struggle to get out of the pit he was in since the death of his parents (and to show that final conclusion for the main character is a strength only a completed trilogy can play out).
There might be a few people that are going to tell you that the ending scene was just a dream by Alfred and he just wished for Bruce to not have died, I for myself am pretty sure that Alfred indeed saw Bruce there at the end in reality, because of the above mentioned reasons. Still one could just see this whole 3-movie-struggle for peace of mind as unsuccessful and fruitless with Bruce's death as the only viable solution, but I refuse to do so for the reason that The Dark Knight Rises's whole motive of rediscovering his will to live suggests otherwise.