As a VFR wood-and-fabric tailwheel pilot, I wonder if my kind of flying will be any different away from major airports.
Nobody uses horses for haulage or transport now - but horse riding as a leisure activity continues.
Nobody uses sail propulsion for commercial sea transport - but leisure sailing has increased over the last 50 years.
It'll be whether you can afford it, just as at present. As regards effect on climate of burning fuel, the example will be set by our leaders. See the R&N thread about the supersonic business plane. No plan for it to use electric engines.