Your assumption is correct - air is pushed into the cabin by the engines, and the pressure is controlled by an outflow valve. An unanticipated hole, assuming it was small enough, would just be compensated for.