I think that will fade. I don't know if you remember how mocked the airpods were when they first came out ("They look like q-tips"). All it'll take is a few celebrities spotted using one and they'll turn cool in no time.
You're not wrong, but I think there's at least a couple of orders of magnitude of awkwardness between the Airpods and the the Vision Pro that will have to be overcome, before the VP becomes mainstream.
There were times when going to an office wearing a T-shirt felt crazy, like going to an office while wearing a bikini, or wearing a clown attire, would be now. It changed maybe in late 1990s.
Things like these change very slowly, then suddenly, once the views of the perceived majority around most people change enough that the people start to see the new state as proper and confirmant, a new norm.
I don't think it will pass, but I think subsequent versions will be slimmer and less mock-prone. In 10 years people will look back at the first version the way people look back at the first bulky cell phones.