As with the case of Martha Lunken, who had all of her pilot certificates and ratings revoked for dammed fool stunt where she intentionally flew under a bridge, The FAA does allow people to reapply for new certificates not less than a year after the revocation as an enforcement action. That being said, is all the flight time that a pilot has previously accumulated prohibited from being used toward the new certificate? Or does such an aviator essentially have to start from scratch and acquire all of the required aeronautical experience flight hours listed in part 61 again?
Yes, flight time from before the revocation still counts. This is from Order 2150.3C - FAA Compliance and Enforcement Program:
A person whose certificate has been revoked may be issued a new certificate provided that the person meets the qualification requirements for the new certificate. To be issued an airman certificate following revocation, an individual must retake all tests, whether written, oral, or practical. Any experience requirements for the new certificate may be met with experience obtained before the revocation.