My honest and probably unpopular take is, excel and word are the most complex applications that most people use. They underestimate how much knowledge they have with that specific software - they know how to do everything they need to do and don't have to figure it out.
When they change to something else, it's natural that they don't know how to do all the things that they know how to do on MS.
The problem is, not having encountered this dynamic before, they misconstrue their lack of knowledge about LibreOffice as poor UX.
It's like a weird form of dunning Kruger.
Of course there are exceptions. I'm sure there are some very specific use cases that LO only poorly addresses and that in those cases people really can't do without MS. However I think the above explains the vast majority of LO hesitance.
Calc has newly added a feature which is similar to "table formatting" in excel. But the feature behaves very weird IMO (filters dont work, you can't remove the "total" row).
I heavily rely on the "smart arts" feature in powerpoint for creating simple visualisations (e.g. to simply visualise an easy process flow). Impress does not seem to have a similar feature.
Having sensible workflows / ux. I don't use writer so maybe that one works nicely but the ux in spreadsheets and especially presentations is quite cumbersome