Theists often claim that the "fine-tuning" of the universe indicates that it was created especially for man by a divine benevolence. Doesn't the fact that the earth will eventually be incapable of supporting any life (when the sun eventually runs out of energy) disprove this hypothesis? And what of the fact that the entire universe it seems will one day be incapable of supporting intelligent life (the big-freeze)?
It's an interesting question, but for many theists it's not obviously a problem. Think about the traditional Christian idea of the Day of Judgment, for instance. If that's set for some finite time in the future, the fact that the universe might wind down sometime thereafter isn't an issue; by then the material world will already have served its purpose. Whether one finds such a plausible is another discussion, of course. But on the narrower question of whether the Big Freeze freezes out the Fine Tuning Argument, the answer is that it depends on the associated eschatology, and for many such, the answer is no.