No, you should not get an iPad Air. Not the current one or the one that might soon hit stores. They are just there to fill the mid-tier and make you appreciate how much extra you get with iPads Pro.
All the Airs are bad deals, style over substance(specs), imho. The 64GB iPad 9th Gen is also a bad deal -very inexpensive but 64GB is not enough.
The fact that there's only a 64GB and 256GB Air really underlines what Apple made it for -To get you to spend $50 more for the way(!) better 11" 128GB iPad Pro M1.
A good option is iPad 9th Gen 256GB, which is the perfect iPad for the vast majority of people including most who own an iPad Pro. It's also often on sale.
Or go for 128GB M1 or 2020(A12z) iPads Pro, 11" or 12.9".
However, you probably don't need a Pro: What people don't realise is that you get the exact same user experience using iPadOS on all contemporary iPads.
iPads are not fully fledged laptops no matter how many Smart Keyboards or Thunderbolt ports they get, or how much RAM it has available or how many inches the display is.
The hardware is amazing but Apple is very deliberately making sure iPads cannot be used as a MacBook no matter how much you spend on it.
Only the components are better on iPads Pro and Air over the 10.2" models. But since there are no nest to Pro apps by Apple in the AppStore(are there any?), you're only rarely if ever going to be using all that power.
Yes, you are going to use your iPad in ways that you would never use a smartphone. But, because of the limitations of iPadOS, an iPad will never be more than a very big iPhone with a phenomenal battery life and a superb stylus for digital artists.
An iPad Air would only be a good deal if it's the 256GB version and you get it for $479-$500.