The Air is just a really good consumer ultrabook. There’s some crossover because the cheaper models of the Pro are comparable in price to the more expensive models of the Air but for me, I know I see no reason to pick up a Pro. I don’t need the performance, and I like the fact that the Air has no fan. Granted modern Macbook fans don’t get frustratingly loud but I love having a whisper quiet machine.
Going off of the Intel era, Apple has typically provided seven years of software upgrades and two years of support for each OS upgrade - or in other words up to nine years total of software support. Hardware support exists on a comparable seven years based on the final sale date of a device.
Under a normal load, an M-series chip is around 15-30°C cooler than an Intel Mac with a fan. Unless you are redlining your CPU every single day (in which case an Air is probably not for you) this will not be an issue. M series chips will also be more resistant to thermal paste decay owing to their lower temperatures.
I run very comparable workloads to you on my Air and I rarely see my CPU tick above 40°C under load. My 2012 Mac mini idled at 65°C by comparison.