Resistive Plate Chambers are used in the ATLAS experiment for triggering muons in the barrel region. These detectors use a Freon-based gas mixture containing C$_2$H$_2$F$_4$ and SF$_6$, high global warming potential greenhouse gases. To reduce the greenhouse gas emissions and cost, it is crucial to search for new environmentally friendly gas mixtures. In August 2023, at the end of the proton-proton data-taking campaign, ATLAS collaboration decided to replace the standard gas mixture (94.7% C$_2$H$_2$F$_4$, 5.0% i-C$_4$H$_{10}$, 0.3% SF$_6$) with a new CO$_2$-based gas mixture: 64% C$_2$H$_2$F$_4$, 30% CO$_2$, 5.0% i-C$_4$H$_{10}$, 1% SF$_6$. The performance of the RPC detectors with the new gas mixture is presented with a particular emphasis on detector efficiency, cluster size and timing performance, as well as the efficiency of the L1 Muon Barrel trigger system.