The problem is that his motivation was to critique "science criticism", but nothing about what he did did anything of the sort. He went about it with the same scientific rigor that one would expect from Derrida, Deleuze, Lacan, etc.
Anyone can feel free to provide examples of this happening, but I don't think there has been significant impact on scientific rigor in top theoretical physics journals and conferences as a result of needling from postmodernists, either during Sokal's time or now. If anything, his identification of "the Left" as the biggest enemy of science was profoundly off base in retrospect.