In that case, if you are dead set on Apple (this is a case where looking at a windows laptop might make sense), I would go with the Pro 8. The Air seems to be for someone who is using it to scroll TikTok and browse the web. It’s not built for long working sessions and can overheat with the lack of fans with heavy use.
This is just my limited opinion though. I’m relatively new to the MacBook world, having spend 20 years with windows machines. Someone with more knowledge than I may be able to offer up a different view.