There is a lot of game theory behind why people mine a PoW cryptocurrency. Attempts to quantify “CO2 per transaction” are fundamentally flawed in my opinion.

Bitcoin’s pollution is not strongly correlated with its transaction volume.

It’s a famous rare collectible. People will mine it whether there is a high volume of transactions or not.