Over many years, I've tried to use OpenDocument Format and failed because of Libreoffice.
Yes, I can see the irony. But ODF has remained far to closely tied with Libreoffice. It is a first-class citizen only on Libreoffice, which works well only on Linux. On MacOS, Libreoffice is terrible...with literally broken UI as evidenced all over the internet. On Windows, MS Office, even with its 365 shenanigans is so much more performant and feature rich, that the main reason anyone uses Libreoffice is because it is free (as in beer). Heck, MS Office is more performant even on MacOS compared to Libreoffice who cannot seem to get basic things like hardware acceleration right. This is the place, where they have a potential market, as Apple's own office suite is much more inferior.
Libreoffice still does not have a proper cloud based collaboration solution in 2025 that is in-built. So when it comes to business use, it is very often a deal-breaker.
The shortcomings of Libreoffice directly hurt ODF. There is a lesson to be learnt if countless users doing the most basic stuff will use a browser-based solution (Google Docs) over your suppoedly more feature rich office suite. Maybe Libreoffice is too complex for someone who can do with Google Docs and just not upto the mark for someone who needs MS Office, and stuck in that uncanny valley.