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.
Considering the number of people who have lived safely like this for years, and that some places (Massachusetts, USA) require it for apartment buildings/multi family units, makes me think it’s pretty well understood
Reading through the article suggests that they aren't completely airtight, rather that the air comes in and out through mostly only through specific paths, with some sort of system that exchanges the heat with air leaving the house, so that the heat (or lack of heat if keeping the building cold) does not leak out much when the air circulates through.