The problem with a fanboys opinion is they focus on the positives and may overlook or disregard a negative. The problem with click-bait YouTubers is they will find something noteworthy and blow it out of proportion to reel in the views.
Real world performance depends on use case. If your a video editor working with 4k video then you will likely be pushing the CPU hard for extended periods quite often. If your a gamer then you will likely be maxing out the GPU and possibly CPU for as long as you play for. If you don’t do any of those you will likely never come across any issues.
It IS important to know that the MacBook Air base model SSD can be slower than the other models, and that it will throttle after 10 mins of maxing out the CPU/GPU, but it doesn’t make the computer shirt, it’s just not ideal for someone who edits videos for a living.
Like someone pointed out, 256 GB of storage is not a lot by todays standards and it’s not going to be enough for todays video editors so it shouldn’t be a big deal, these people are more likely to go for a 14” or 16” Pro.
The limitations are not likely to affect the casual user. Likewise if your coming from a machine that is more than a couple of years old then this will still be a fantastic improvement. If your editing videos on a 2018 MBP then the new M2 Air will be a big improvement, even with throttling. Not ideal, but an improvement.
But yes, Apple decided to save money by only buying 256gb nand chips and above which made the M2 base model SSD slower than the previous M1 model, the majority of everything else looks to be an improvement.