... 2016 XL Denali ... 6.2L, 8L90E ... 3.23.
Would replacing those with 3.42 have any huge positive impacts on drivability?
Short answer: NO.
Long answer: you used the word 'huge' - only going from 3.23 to 3.42 will not have a HUGE impact.
That said, of course it will have an impact. Provided you drive it 'less-than-enthusiastically',
more axle gear will improve city / metro / urban MpGs,
improve unladen highway MpGs (under 65MpH or so - over that speed, MpG benefits fade),
improve towing/hauling MpG
MpG benefits will NOT be HUGE, but they'll be measurable (unless you're leadfooted).
More assertive axle gear also takes some strain off the 8L90, so it'll go longer between rebuilds too.
Please note:
1. unless using VERY tall tires, 3.73 will be overkill with 8L90; 1st gear'll become almost useless
2. for maximum MpG & durability / longevity benefits, have your ecm and tcm tuned as well