Transparency mode works well on Airpods pro but I never walk around busy streets with both earbuds in. I strongly recommend only using one and listening to audio books or podcasts
I guess part of it is that I don't really feel a need to always be listening to some kind of soundtrack. I actually do listen to podcasts when I drive, especially on the highway. But I don't even routinely have music on in my house and don't really like working with music in the background.