(Disclosure: I write 99% of my stuff in Emacs now, so I'm not going to go that far out on a limb for iWork. It's just that it's the best "Works"-style suite that I've used.)
I also like Apple's office suite, the problem is network effects. I'd even argue most people don't actually need MS Office. The amount of people using PowerQuery, VBA, etc. is probably less than 2% of users.
The problem is, because everyone else (in business) already has and uses office, if you want to collaborate, that's what you have to use. Open file formats didn't win out in the end.
This is absolutely the problem - with the added issue of platform support.
I’m the only Mac user in our company of 15, which means I’m also the only person that can open a .pages file. Anyone can read a .docx, and if authored in word it will actually look the same on both computers.