For me, the most important considerations when trying to decide between the M2 Air and the 14" M1 MBP were - adequate horsepower, extreme portability, battery life, lap-ability, and battery life.. And did I mention battery life? I need a laptop that has enough power to do my daily tasks, which include running VS Code, web applications and database applications hosted locally, a Parallels VM running Windows 11, and many concurrent tabs in Chrome and Safari. And it needs to be able to do it for an 8 hour day away from a power cable. I spent nearly 2 weeks doing a side by side comparison between the base 14" and the M2 Air (10/16/1Tb), and came to the conclusion that the M2 Air ran all of those tasks without breaking a sweat. It *never* gets even slightly warm to the touch. It's feather light -- it feels nearly identical to my iPad Pro 12. The battery lasts friggin forever. I've worked unplugged for 10 hour days and still had 30% battery left. The 14" screen gave me blinding headaches after 5-6 hours of use. I've never been sensitive to PWM screens before, but the one in the 14" made up for lost time. I also prefer the look and feel of the M2 Air over the thick and retro bar-of-soap look of the MBP. In fact, the first time my wife saw the Pro, she looked at me and said "man, that thing is thick and ugly! What was Apple thinking?" And I agree, the slab sides of the Pro are not exactly aesthetically pleasing. They could have lopped off a fair bit of thickness by going with a mDP port instead of HDMI. Anyway, I ultimately went with the M2 Air -- I don't need native support for 2+ monitors. My second monitor is my iPad Pro using Sidecar. I don't need the ability to render 4/8K video for hours at a time. I have a very nice usb-c adapter to pull in SD card data from my cameras and hook to HDMI monitors, which is arguably easier to carry when needed than lugging around the MBP all of the time with the .01% chance I'll need any of those extra ports.
If you NEED the sustained horsepower of the MBP, then by all means get the MBP. I don't and likely won't. I'd wager that 98% of MacBook buyers don't either. If saving 2 minutes of processing time when processing the one video a year you import is worth the weight and battery life sacrifices that come with the 14", then by all means, man up. If having the most powerful laptop you'll never actually fully utilize makes you sleep better at night, you do you. If you absolutely have to be able to plug in two monitors into two thunderbolt ports, rather than using a single plug Thunderbolt dock with 2 outputs, then you have no choice but to buy the 14". But if you browse the web, import some photos every few months, edit docs using Word, video conference, watch YouTube and maybe stream some movies every once in a while, then you don't need the 14".. I can assure you that the M2 Air is MORE than up for the task.
For me, the M2 Air met every single one of my high priority needs, and will easily meet every single tertiary need, both now and in the future. I didn't feel the need to go buy a Ford F350 for the once every three year occasion where I wanted to make a lumber run in a single trip, when I could own a more daily practical vehicle and make 2 runs instead.