There's no doubt the M2 Air 15" is underpowered for some types of task. For example, as part of my data science workflow I need to decompress a few thousand text files. It takes ~2x as long on an M2 Air compared to a 12-core M2 Pro MBP 14". The M2 Pro is very fast, but my desktop 7950X is 2x faster still on the same task, a whopping 4x faster than the M2 Air.
For anything that needs just a few cores, the M2 Air is definitely more than enough and just as fast as the Pro and Max chips, which is to say, very fast indeed. But for multicore workloads it really can throttle, often quickly, and you end up with the equivalent of maybe 6 cores.
The better power efficiency of the M3 chip will likely solve this issue for the M3 Air (assuming it still has 8 cores).
For anything that needs just a few cores, the M2 Air is definitely more than enough and just as fast as the Pro and Max chips, which is to say, very fast indeed. But for multicore workloads it really can throttle, often quickly, and you end up with the equivalent of maybe 6 cores.
The better power efficiency of the M3 chip will likely solve this issue for the M3 Air (assuming it still has 8 cores).