Firstly, I've got my fingers crossed that this will turn out half decent. At the very least, I hope they'll have some nice Federation ship designs (no bridge windows please!). However, if the Enterprise having been lost with all hands is the reason he left Starfleet, then I hope it's something that Q can resolve. I enjoy enough shows that are dark and depressing without one of my all time favourites being turned into that. I don't think there's a single person hoping his former crew/family won't turn up at some point.
Fingers crossed.