"Rowdy" Roddy Piper -- the kilt-wearing heel who headlined the first WrestleMania and helped the WWE push other professional circuits out of the spotlight -- has died in his sleep.