RH is honestly a lame moisture measure, meteorologists really don't use it too much. Because it doesn't mean much, it really just reflects that temperature fluctuates each day. And that's not ground breaking information! When forecasting severe weather or precipitation or snow or tropical cyclones... it tells us almost nothing of use.
Dew point, which is probably the most used absolute measure of water... is much more informative to us. It really focuses in on how much water is in the air (which is important for forecasting almost everything weather-wise)
And notice if anything, that dewpoint is going the same way as temperature instead of the opposite.
So this graph shows relative and absolute humidity typically fluctuate in two opposite ways to the temperature.
And so hopefully it makes sense that if it's getting warmer, those opposing trends would be a reasonable result. The overall water goes up... the "fullness percentage" may well still go down.
If total moisture goes up a bit, but the atmosphere's moisture cap goes up much more, it would mean RH and AH change in opposite directions. Since evaporation requires more energy, meaning for weather the dew point is much slower to change than temperature... it lines up that this would be the trend.
Absolute and relative humidity do both "measure" water vapor in the air. But because one, RH, really is more a (inverted) temperature measurement masquerading as a moisture measurement, rather than truly tracking water changes... they still can and very often do move in opposite ways.
(Just a side note: absolute humidity can often be a bit more stable and independent from temperature, more so than this graph suggests. Wind changes like fronts and sea breezes can mean more connected movement, because different airmasses are coming in. It's fall in MN, so there's some of that going on.
But hopefully graphs for other areas can help you explore the trend more and be convinced of the main ideas: (Orlando, San Antonio, Seattle, Phoenix, Nairobi Kenya, Tehran Iran, Singapore, Sydney Australia, Guam)