Pro will get you better performance from the chip and active cooling, as well as a better screen. If the weight isn’t an issue go for the pro.

M2 Air is really good, according to your usecases you don’t need anything more than that.

M1 pro is miles above M2, but both are gonna crush your workload. With double the ram, the pro will perform much better in a couple years compared to the air, even though the air might get maybe 1 year more of software updates. I’d recommend the pro, purely for the ram and better chip giving more room for better performance in the future.