> Lightning and similar are making steady progress which would reduce the carbon footprint

They might bring down transaction fees, but most of the money in mining is from block rewards, which depends on the market price of Bitcoin rather than transaction volume.