A 10 percent increase over atmospheric pressure might not seem like that much, but it's enough to notice, and would probably be uncomfortable. It's like being under 1 meter of water. It's also enough to break large windows.
This is, by the way, why hard drives have filtered air holes rather than being completely sealed.
No, the ideal structure should minimize heat loss from air exchange.
I'm not fully up on my air exchange rates, but it's fairly typical for ranges to be in the 4-20 range, that is, the interior air is exchanged with the exterior 4-20x per hour.
In my Thorsten Chlupp references elsewhere you'll find he makes extensive references to heat exchangers which minimize thermal losses. He does this by a twofold process for his Fairbanks, AK, homes: entering air is routed first through the ground where it's heated from very cold ambient temperatures of as low as -40C / -40F to a temperature closer to freezing (~0F). It's then passed through a heat exchange where the exiting warm air transfers much of its heat to the entering cold air.
The purpose of tightly sealed windows and other possibly entry/exit points isn't to eliminate air exchange so much as to control it: you want air entering and exiting through your designated ventilation systems and transferring heat properly, not traversing the envelope arbitrarily.
See:
Chlupp discussing this issue: http://www.greenbuildingadvisor.com/community/forum/general-...
http://www.engineeringtoolbox.com/air-change-rate-room-d_867...
Another way of putting it: A well-designed structure should minimize random, unintentional air exchange, but provide sufficient deliberately-engineered ventilation to keep the air and people happy. For efficiency, that ventilation should go through a heat recovery ventilator (HRV) or energy recovery ventilator (ERV) as appropriate to the climate and budget. (An energy recovery ventilator also exchanges moisture).
Beyond Chlupp, Lstiburek is a great engineer and writer on these topics.
With regard to letting a house cool down at night, that's impossible. If you heat a quantity of air from 273 K to 300 K at constant volume, the pressure increases from 1 atm to 1.1 atm. That may not sound like much, but it's better expressed as a pressure differential of 10 kilonewtons per square meter, and the surface area of your house is such that it could severely damage the walls and blow the door open -- popping it like a balloon.
(The fundamental mathematical error made by those who minimize this effect is ignoring the surface area of the building)