Lots of people have posted "I have the same problem" (as Answers!). I am not sure that everyone has the same platform, but anyway:
im having the same problem too and im using parrallels for mac on my macbook pro im hosting windows 11 pro on it. is there maybe an sql server express for macbook installation? or has that not been created yet?
SQL Server does not run on ARM, and I would deem it unlikely that the main version of SQL Server ever will run on ARM. Bear in mind that the main market for SQL Server is enterprise solutions. I can't see that ARM is a target there. The fact that it is popular among developers to use ARM-based PC is not likely come anywhere near close to the bar for the investment.
There is SQL Server Edge, a specialised IoT version that runs on ARM, but with less capability.
I believe the most common solution for running SQL Server on MacBook is to use Docker. I don't have any bookmarks for this handy at the moment, as I am on the road, but Google should be able to help you.