Here is a Rolling Stone story about the estimated carbon footprint from all the streaming, with some comparison to how much impact that creates compared to the amount of plastic used to make vinyl records and CDs.
The amount of that plastic has gone way down (from 61 million kilograms in the 2000s to about 8 million kilograms as of 2016), but at the same time the amount of carbon released into the atmosphere that can be fairly attributed to the amount of power required to serve all that streaming is huge and dwarfs that amount of plastic:" the amount of GHGs (greenhouse gases) generated by the energy needed to transmit music for streaming is estimated to be between 200 and 350 million kilograms." The story also cliams, " Data centers are reportedly responsible for about two percent of the world’s greenhouse gas emissions, a carbon footprint nearly equal to the airline industry."
Something of an apples-to-oranges comparison, but it does point out an inconvenient truth: streaming carries an environmental cost, even if it makes people feel like they are living more lightly on the earth by doing that instead of collective physical media. Indeed, it looks like worldwide, the carbon footprint of streaming is bigger than it ever was for physical media, and growing.