Display omitted •Micro-macro sound absorption correlations for various microstructures have been established using the JCAPL model.•Smaller porosity for better noise reduction at low frequencies, and the opposite at high frequencies.•As the different distributions of sound resistance and reactance, the porosity of 76.4%–82.0% has the best performance.•High porosity materials are more sensitive to changes in sound absorption properties caused by changes in prism length. With the increasing prominence and complexity of environmental noise problems, there is an urgent need for novel acoustic materials to meet noise reduction requirements. In this paper, two auxetic microstructures and three typical lattice microstructures are established, and a microscopic-macroscopic acoustic performance study scheme is established through the Johnson-Champoux-Allard-Pride-Lafarge (JCAPL) model. Auxetic-BCC porous materials have lower acoustic resistance and reactance amplitudes than many typical porous materials through experimental verification and comparative analysis of numerical calculations. The porous material's thickness and the backing cavity's thickness have similar effects on sound absorption performance when controlling a single change in structural parameters, and there is an optimum thickness. As acoustic resistance and reactance are dominant at low and high frequencies, respectively, noise reduction is better at low (high) frequencies than at minor (large) porosity, and the porosity of 76.4%–82.0% has the best sound absorption effect. Changes in prism length of materials with high porosity are more sensitive than those with low porosity, so the prism length with porosity of 76.4%, 79.0%, and 82.6% shall be designed to be less than 1.1 mm, 0.9 mm, 0.8 mm, respectively. This study provides theoretical guidance for designing multifunctional porous materials in extreme environments.