iPad is more limited in features and screen size and also, more fragile.

The screen is actually debatable. 15” vs 14”. MBP has Mini-LED but MBA screen doesn’t have PWM which is more eyes-friendly for people with sensitive eyes & long term usages.

I thought M2 15 battery life is better than MBP 14. To OP: it comes down to whether you need fan (due to very heavy load), also how much benefit of better screen, better speaker in MBP and lighter weight in MBA for your typical usage.

MBA wins on weight and price. Also, if you’re referring to MBA M2, the screen is more eyes-friendly than MBP (for some people with sensitive eyes). If I were you, I would get MBA either 13” or 15”. Use the remaining money to upgrade storage or RAM (look like you need more storage than RAM).