Of course it didn't have the opposite effect. It's now very much the norm (where I am) for people to bring these bags to the supermarket / grocery to pack their goods.
And to back up my claim: https://www.theguardian.com/environment/2023/jul/31/governme...
"Supermarket plastic bag charge has led to 98% drop in use in England, data shows"