The core of COM is about allowing binary code to be used from any language through a standardized interface.

As pjmlp mentioned, this part was very successful and all new Windows APIs are based on it.

The COM which failed and which you are thinking about was related to OLE and the idea of embedding Excel sheets inside Photoshop drawings, ...