It's hard to say for certain without having heard it in person, but my experience having owned a couple Yukon XL Denali's is that the compressor rarely runs, and if it does you hardly notice it when driving especially with music playing. It is even hard to notice at a stop light with no radio. Ride quality would be noticeably more firm for even front seat driver/passenger when the bags are heavily inflated.
The bags should always be firm if you squeeze them with your hand, but shouldn't be rock hard if you don't have a trailer/loaded cargo area. With how much your compressor runs I would expect the rear ride height to be high as well (cat in heat).