Doesn foam make the home too tight?
There is no such thing. A jet airliner is as tight as it gets and it does not have moisture and humidity issues. The reason is the HVAC system has been properly loaded to account for this. Your home will need to be designed the same way. Most plumbing and heating companies have switched to computer aided software that loads the home and tells them what to install so issues don’t arise.