Bottom line: If he is unwilling to make some concessions (counseling, help for his depression, doing marriage exercises from a book, etc), then I sadly don't see much hope for their marriage. She needs to hope for the best, but plan for the worst.
I really, really hope he wakes up and decides to do something to help the situation. Hugs for your sister.