Ironically, no. I've done this, and the $%^#ing aptasia perks right back up after a few days.
Also, I really don't think you killed the "live" rock....if by live you're referring to the bacterial population. Certainly many (not even all!!!) of the larger critters passed on to that great aquarium in the sky, but much of the bacteria is *in* the rock, not just on the surface. Fresh water would cause many single-cell and simple multi-cell organisms to lyse (burst) but the bacteria we're interested would still be present in enough numbers to remultiply pretty darn quickly. And the bacteria we're most interested in, the critter that breaks down nitrate, is anaerobic in nature, buried deep in the rock, and wouldn't have been harmed by this at all.
In short, I don't think you killed your live rock.
Now, here's a similar question for everyone: I have a piece of live rock that's been sitting in saltwater for a couple months now without any sort of filtration, water movement, or light. It's very stale, dead water, probably hypersaline at this point. It's covered with cyano. Think the rock is still 'live?' More importantly: is it worth saving???
