When the activated ability resolves, determine whether the targeted spell would destroy a land if it resolved right then. If it would, then counter that spell. Otherwise, it is not countered, even if the spell could, under other circumstances, destroy a land.