Airtight isn’t really the best way to describe it. Rather it’s controlled air exchange, this way instead of 1000 tiny leaks all over you have a central controlled means to exchange air.
Passive home typically have ERVs or HRVs (Energy/Heat Recovery Ventilators) to achieve this, they can control the heat/humidity in the air.
Most passive houses I’ve seen have windows that open, but they are typically double/triple glazed (depending on climate) and are casement style instead of the more typical (and inefficient) double hung. They also typically feature a ventilation system to manage air movement precisely to prevent the issues you’re concerned about.