Newer Microsoft Office documents are represented by ISO standards and the LibreOffice/OpenOffice OpenDocument formats by different ISO standards. In a nutshell that means that most third-party word processing, spreadsheet, and presentation applications are designed to open Microsoft and sometimes both standards documents. Both LibreOffice and OpenOffice are Microsoft Office suite clones and do both document standards.
Apple's Pages, Numbers, and Keynote represent Apple's own, proprietary document standard and only Apple's applications can open their own documents — and then it will depend on the age of those documents, and the version of the applications. Apple's applications can potentially open Microsoft Office documents read-only if they are not damaged, not too old, or do not use Microsoft features that Apple's translation process was not designed. And, because Apple's applications are not clones of Microsoft applications, you can never be certain if they will translate correctly in either direction.
If you are not sharing your Microsoft documents with anyone, then it is your call whether you use Apple's Pages, Numbers, and Keynote to perform document transformations into a proprietary format.
You can choose to use the free LibreOffice, or continue with OpenOffice as they are free applications and supported on macOS Catalina and later. There are paid third-party MS Office clones that are quite well done that can open Microsoft documents in their native format. SoftMaker has Office 2024 for Mac. I don't benefit from mentioning this vendor.