Does the MacBook Air's fanless design struggle under sustained heavy workloads?

Yes. The MacBook Air’s passive cooling works fine for casual tasks, but under sustained heavy work like video rendering or compiling code, the chip will throttle due to heat buildup. For that kind of work, you need the MacBook Pro with active fans.