Properly built porc can beat off an astonishing amount of attackers. It's probably a good thing to have a superweapon or a game could last for hours even after a team is doomed.
That said, there are a few counters.
1) Silo. Mass launched shockleys can incapacitate a SW for long enough that a team can win
2) Massive air bombardment. Often guys build a SW without proper air defences. I've seen airstrikes kill a DRP more than once.
3) Another SW. You can always build your own.
4) Nux. A SW with insufficient antis can be beaten like that, in the sense that a nuclear strike can soften up the defences enough for attackers to get through.
Usually a SW happens when one team has massive eco superiority and the other doesnt.