The presence of organic co-substrate in groundwater and soils is inevitable, and much remains to be learned about the roles of organic co-substrates during pyrite-based denitrification. Herein, an organic co-substrate (acetate) was added to a pyrite-based denitrification system, and the impact of the organic co-substrate on the performance and bacterial community of pyrite-based denitrification processes was evaluated. The addition of organic co-substrate at concentrations higher than 48 mg L−1 inhibited pyrite-based autotrophic denitrification, as no sulfate was produced in treatments with high organic co-substrate addition. In contrast, both competition and promotion effects on pyrite-based autotrophic denitrification occurred with organic co-substrate addition at concentrations of 24 and 48 mg L−1. The subsequent validation experiments suggested that competition had a greater influence than promotion when organic co-substrate was added, even at a low concentration. Thiobacillus, a common chemolithoautotrophic sulfur-oxidizing denitrifier, dominated the system with a relative abundance of 13.04% when pyrite served as the sole electron donor. With the addition of organic co-substrate, Pseudomonas became the dominant genus, with 60.82%, 61.34%, 70.37%, 73.44%, and 35.46% abundance at organic matter concentrations of 24, 48, 120, 240, and 480 mg L−1, respectively. These findings provide an important theoretical basis for the cultivation of pyrite-based autotrophic denitrifying microorganisms for nitrate removal in soils and groundwater.