My thoughts on the matter are pretty similar with everything posted here up to this point. The one rather unsettling thought I had in addition to these is that perhaps Pike was scared further by Spock's intrusion...perhaps it reminded him of the whole Nero/Narada event and that surely would not bring the man any comfort.
The look on Pike's face as he passed looked blank..except for the tear rolling down his cheek...I hope this is not because he was terrified with the reminder of Nero and the slug etc.
I found this portion of the movie to be extremely upsetting and could do without ever seeing it again. I would so much have preferred that a message was passed along to Kirk..but I guess it just wasn't meant to be.