MS makes almost no money on the Macs to begin with...and has not for several decades. First, Apple only has, at best, year after year for 30+ years, 7% of the Personal Computer space. That's such a tiny segment of the Personal Computer market. Think about it: if one piece of the market supplies 93%+ of your potential customers and the other segment of your market supplies 7%, who are you going to write your apps for?
Second, out of the few million Apple Macs that are sold each year (10-20 million source:
https://www.statista.com/statistics/276308/global-apple-mac-sales-since-fiscal-year-2002/ ) , only a minority purchase MS Office. A miniscule share want to run Windows on a Mac. So to say that this "would actually be quite a money making opportunity for MS" is nonsense and most likely not worth Microsoft's time other than to promote that MS now supports ARM in some capacity to make some folks happy. "But what about all the iPads and iOS devices that are ARM?!" folks will say. My reply is that practically nobody on a touch screen iOS device is using MS Office. So again, this is not going to make much money for Microsoft.
Microsoft is going to concentrate on where the sales and profits live: non-Apple world. Dell shipped 260 MILLION machines in 2019...Lenovo shipped 60+ million. Then factor in Toshiba and all the other Wintel players. Again, I'm sure MS will happily accept some revenue from Mac Arm folks, but it's tiny peanuts compared to the Wintel vendors out there.