Once associated with coal and pollution, the mining industry has cleaned up its image as more Australians recognise its importance in the net-zero transition.