This too shall pass, my friend. The initial shock and embarrassment is often worse than any long-term fallout. If your work is good and you're professional going forward, this blip won't matter in the grand scheme. We're all human. If anyone says they've never messed up, they're lying.