In theory transaction fees will be what solely rewards the miners. In reality though, unless computers become smarter, faster and smaller this wont be profitable most likely. But I'm sure by then that another currency with a more Eco-friendly consensus, and more profitable rewards will surface. We should start looking to more sustainable Cryptos. There are many coins that are potentially "better" than bitcoin.