The propensity of foamed concrete to absorb water results in a consequential degradation of its performance attributes. Addressing this issue, the integration of aerogels presents a viable solution; however, their direct incorporation has been observed to compromise mechanical properties, attributable to the effects of the interface transition zone. This study explores the incorporation of MTES-based aerogels into foamed cement via an impregnation technique, examining variations in water-cement ratios. A comprehensive analysis was conducted, evaluating the influences of MTES-based aerogels on the thermal conductivity, compressive strength, density, chemical composition, and microstructure of the resultant composites across different water-cement ratios. Our findings elucidate that an increment in the water-cement ratio engenders a gradual regularization of the pore structure in foamed concrete, culminating in augmented porosity and diminished density. Notably, aerogel-enhanced foamed concrete (AEFC) exhibited a significant reduction in water absorption, quantified at 86% lower than its conventional foamed concrete (FC) counterpart. Furthermore, the softening coefficient of AEFC was observed to surpass 0.75, with peak values reaching approximately 0.9. These results substantiate that the impregnation of MTES-based aerogels into cementitious materials not only circumvents the decline in strength but also bolsters their hydrophobicity and water resistance, indirectly enhancing the serviceability and longevity of foamed concrete. In light of these findings, the impregnation method manifests promising potential for broadening the applications of aerogels in cement-based materials.