The performance of resin anchoring agents in deep coal mine roadways is significantly compromised by water-bearing and chemically aggressive conditions, posing a major threat to support system reliability. This study aims to systematically quantify this performance deterioration and develop a more resilient material solution for these challenging environments. A comprehensive experimental program was conducted, including uniaxial compression, pull-out, and interface shear tests, accompanied by the systematic improvement of the resin formulation and microstructural analysis via Scanning Electron Microscopy (SEM). The results showed that increasing borehole water content to 30% reduced the compressive strength of conventional resin by over 40%, while acidic environments (pH = 5) caused a 70% drop in its interfacial shear strength. In contrast, an improved formulation incorporating hydroxypropyl acrylate and a super absorbent polymer (SAP) exhibited a 20% higher initial strength, maintained over 85% of its strength under water saturation, and retained functional residual strength in acidic conditions. SEM analysis confirmed that the improved resin’s denser microstructure suppressed interfacial microcrack formation. The findings demonstrate that the improved formulation provides a robust material basis for enhancing the long-term durability and safety of anchorage support systems in extreme underground engineering environments.