A lot of factors speak against this stuff.
First, I doubt that the Seals could have kept this a secret so long.
Second, the White House watched this on video, in real time.
Third, claiming unnamed sources is an excellent way to try to fabricate something. Hersh also wrote very weird, over the top stuff about Bush 43 and I remember that that that time, the Right didn't like him very much.
Fourth, the fact that El Quaeda itself has confirmed his death pretty much closes this.
Fifth, a journalist can find someone who, for $$$, will say almost anything.
Take a look at the crazy people who claim that the moon landings were faked.
The strongest piece of evidence that this is not true and that indeed the moon landings happened exactly as recorded in our history books?
Russia.
Yes, Russia, for at that time, at the height of the Cold War and in the middle of a space race that they, the Russians, were going to lose, they had exactly the same type of satellites in orbit as we, their technology was right on par with our own. Had we not really sent a spacecraft to the Moon not just once, but many times, the Russians would have screamed bloody murder and brought forth sensor evidence to prove that we were never there.
Yepp, the Russians themselves prove that the Moon landings were quite real.
Rational, intelligent people understand this.