The lisp macro system can more or less be done at compile time, yes, but that's not the problem with other languages. The format of lisp makes it especially easy to do macros - code is data!
Here's an example. Take, for example, this class declaration:
(defclass dog (animal)
((size :accessor dog-size)
(name :accessor dog-name :init-form "Fido")))
How do you make that into data? Easy. Just quote it:
'(defclass dog (animal) ...)
Now take the equivalent in Java:
public class Dog {
int size;
String name = "Fido";
}
How do you get that into data? Well, I suppose the best you could do without modifications to the core language is just put it in a string. But then to do something useful you'd have to do so much tedious string parsing it wouldn't be worth it. I suppose you could invent a special ParseTree class or something, and a quote operator, and etc etc, but that wouldn't be nearly as easy as Lisp makes it.
What the previous poster was saying is that once other languages have a code representation that is easy to work with as data, and can manipulate that code as data at compile-time to produce complex macros, then Lisp might fade. (At least that's how I understood it, correct me if I'm wrong.)