I am currently sketching a novel about people at the end of time, some months or years before the Big Crunch:
There is a space station full of people who can only sit and watch as their final moment draws closer and closer. There are several different characters involved, from the rational boss, who tries to keep everything running (why? Because it's his job, he's responsible to make sure everyone survives as long as possible), to some religious people who finally meet their gods, to some young overly curious scientists who cannot wait to see what's coming, to the depressive maniac, who tries to blow up everything before the Crunch.
My problem is: From the beginning on, the reader will know, no one will survive and the let's call him Captain is fighting a useless struggle, because it is the Big Crunch. He can basically only sit and watch and help others getting along in their final moments.
Is this idea worth being written, or will the obvious ending drive readers away?