Although the cooler of the bottom card is completely cut off by the top card, overheat is not likely: there are special holes in the appropriate part of the PCB.
The GeForce 7900 GT2 takes its air for cooling from both sides at once.