Holes in doors are for WATER to drain away, that is rainwater that hits the glass and falls down past the rubber seal, the door should be pretty sealed to the inside cabin, that is why there should be a plastic sheet over the hole door.
It's a fitment or mechanism problem that's causing it.
It is not such a problem on sierras with ventilation, but certainly is on newer cars as makers try to get them ever more silent, adequate through flow of air decreases as it promotes noise.
You could always fit the sunroof deflector, this also allows the roof to be wound back and cuts down on noise massively..
tabetha