"What good will science do for you once you're dead?" Nothing, but what good does religion or spirituality do when you're dead? In fact what good does any "X" variable do when you're dead? Whether there is an after life or not is a metaphysical question and as far as we know, nothing in this life has anything to do with an afterlife. There's also no evidence that there is an afterlife, so why believe there is?
It doesn't make a difference whether you believe there is a an afterlife or not through spiritual, religious, philosophical, or scientific means. If there isn't an afterlife, then your beliefs had no effect on the lack of an afterlife.
However where science has made tremendous improvement is on the average-life span of human beings. Science has caused us to be able to live much much longer. Keep in mind this is the one and only life that we know for sure is real. So science does deserve lots of credit.
