Has google sheets filled out the lambda helper functions yet? If so that could narrow the gap.
Passing around vba based xlsm is really awful, so if google sheets has lambdas they can probably get a lead with google sheets queey language over filter.
Groupby and pivotby are the new excel alternative, but if they filled out lambdas, then does that keave VBA and power query as the only reasons for Excel?
Not sure what lambda helpers are. But you can write Google AppScript which is just JS and do some pretty cool stuff, including define custom functions and fully integrate with Google APIs. I've used to to send emails, or create calendar events for example.