We know that civilization will survive cancer just fine. We do not know the same about asteroid impacts or global warming.

So in terms of potential future lives saved space exploration and fighting global warming are worth a lot more than cancer research. After all there has to be someone to get cancer in the first place.