IDK, I'm expecting Vaughn to die. He is already REALLY old. There comes a time when they just need to let nature catch up to him.
I think he'll wake up. I also think his Starfleet days are over and he won't make a full recovery. A disabled character could be interesting.
Who really needs to be allowed to die is McCoy. He looked incredibly frail and retired over 20 years ago, and we're supposed to believe he is still working during the Borg cleanup? Ridiculous.