Macros use the Visual Basic for Applications code library. This library is quite large. It is installed together with the desktop version of Office for Windows and Mac.
The online versions of the Office apps cannot use that library - they are intended to run entirely within the browser, without relying on installed code libraries, on all platforms (not only Windows and Mac, but also Linux, Android, iOS/iPadOS).