I would get the M1 and never look back. Be sure to check that any necessary apps you have will run on it here. But for most people, it will be just fine. The speed is fantastic; battery life is great too.
As Apple progresses, Intel Macs are going to depreciate more quickly than Apple silicon Macs. At this point, I only recommend an Apple Intel Mac if someone needs Intel for a business reason or Apple doesn’t make the form factor you need (such as an iMac).
I say this to you, typing on my MacBook Air M1 that is sitting on the same desk with my iMac Pro. After having run the M1 chip for several weeks, I know that I will replace the iMac Pro as soon as Apple releases a similar desktop on Apple Silicon.
Advantages to the Pro - longer battery life, Touch Bar, and sustained high workload. If those are important then consider the Pro, otherwise the Air will be fine. I’m currently using an older Air with 8gb and 1tb with a workload not dissimilar to yours. Memory pressure never gets out of the green. If buying now, I would get 16gb and the 1tb because I like having everything internal on a laptop.