I don't think a lot of people who are in the know have any expectation of this turning around and going well, but I don't blame anyone for hoping it will. The existing communities that are uprooted from all this, not to mention the headaches of signing up for new platforms and all that entails, aren't exactly ideal. Avoiding them from being necessary would be fantastic... alas, that hope is indeed slim.
Indeed, if the prices were reasonable this would not be a problem. I believe that the Apollo developer even said as much (or maybe it was rif's developer - or neither and I'm just imagining it) - and I have no objection to it either, the servers aren't free to run after all. But the rate the used? It's just absolutely fucking incomprehensible.
The shitty treatment of third party developers is just the unmentionable icing on this already disgusting cake.
Whether it's worth learning or not depends on what you're trying to accomplish. The basics are easy enough to pick up and don't deviate much. It's only when you get a bit deeper in that stuff starts diverging.
As for use case: If I was strictly looking for private use, I would absolutely pick LibreOffice over the alternatives (cloud-stored data is, ah... well it's a thing until it's not.) I did not use it extensively when I did try it (Windows and Ubuntu) so I wasn't quite able to get used to some of the differences. Likewise, there was far more information available for the Microsoft Office and Google Docs suites, but that is more a matter of mind share than quality of the software.
Right now I have no need for that kind of editing outside of work, and for work, I just use what's provided. Currently that's Google Docs and has been Microsoft Office in the past. I don't know that I'd steer away from either of those for a decently sized business - something being industry standard means it's something people are used to working with, after all - but for a small outfit, I'd probably go with LibreOffice still.