Each and every one of your points can be solved without Microsoft lock-in, and are issues with any software migration. The fact that MS make it so much harder to migrate than other solutions is the main reason I can see for making the transition ironically.
Macros are barely even compatible between Office versions, so I don't really see that as a strong point. I usually see macros being used by people who don't know how databases work to perform functions (using a lot more code) that a database could do in a jiffy.
Without you going into specifics of what addins you use, it's tricky to say much more.
Sharepoint has terrible lock-in and could be replaced by a number of collaborative software solutions.
DRM for secure govt documents? How would DRM help? Honestly.
I'd argue that Libre Office is ok for advanced users, who know what tool to use for which job, but really basic
people users should probably stick to what they know and let the world overtake them with more powerful, scaleable, transferable, automatable, open solutions.