I use Asahi too, and at the moment the killing factor is battery depletion while sleeping (50% a day!). Performance wise, working with kdenlive is about on par with an i7 12th gen Intel chip (direct comparison between Thinkpad X1 i7 16g ram 2023 and mbp m2pro 16g ram) - nothing close to the power macos can leverage from the m chip but still perfectly usable. But frustrating in a way.
If you install Asahi, it will be dualboot by default - why not trying it out? The install process is a delight, very well explained.
As for hardware, the Air is pretty unique. There are other fanless stuff out there, but it’s gonna be cheap netbooks without the power to handle video work.
I’d say give Asahi a try ; I love booting mine in front of people and looking at their confused faces when I spin the cube to move a wobbly window around (Though the big Fedora logo at startup is a bit of a giveaway)!
Edit: also, you already own the hardware. Stop wasting money/resources, jut make it do what you want.