My feeling, without sources at hand to confirm it:
In few Asian countries, we can see it did helped many.
In most developing countries, the picture is less clear.
In developed countries seems to have benefits to the richer top 20%, and have neutral or negative effect on other...
There are a lot of negative externalities associated with globalisation (eg pollution, weaken state...)
And it is absolutely not clear how would have done people in different scenario...
Developed countries seem to have outsourced or automated many formerly middle-class manufacturing and office jobs.
New jobs tend to be high-end tech jobs or low-end service jobs. (And even some of the are being automated.)
An obvious benefit from globalization and automation appears to be providing more affordable consumer goods.
Unfortunately (and for various reasons) housing, higher education, and health care have become drastically more expensive (in the US at least.)