Climate change from anthropogenic carbon dioxide (CO2) emissions poses a severe threat to society. A variety of mitigation strategies currently include some form of CO2 capture. Metal-organic frameworks (MOFs) have shown great promise for carbon capture and storage, but several issues must be solved before feasible widespread adoption is possible. MOFs often exhibit reduced chemical stabilities and CO2 adsorption capacities in the presence of water, which is ubiquitous in nature and many practical settings. A comprehensive understanding of water influence on CO2 adsorption in MOFs is necessary. We have used multinuclear nuclear magnetic resonance (NMR) experiments at temperatures ranging from 173 to 373 K, along with complementary computational techniques, to investigate the co-adsorption of CO2 and water across various loading levels in the ultra-microporous ZnAtzOx MOF. This approach yields detailed information regarding the number of CO2 and water adsorption sites along with their locations, guest dynamics, and host-guest interactions. Guest adsorption and motional models proposed from NMR data are supported by computational results, including visualizations of adsorption locations and the spatial distribution of guests in different loading scenarios. The wide variety and depth of information presented demonstrates how this experimental methodology can be used to investigate humid carbon capture and storage applications in other MOFs.