@cowanon The answer to that would depend on the fuel source mostly. We currently dont have the ability to reach near-light speeds though with a nuclear rocket will get fast, but not near-light.
In the end though remember this, whatever energy output you get from the collision will be significantly less than the energy you put in accelerating it. So whatever fuel source you use to accelerate it you'd be better off just blowing the fuel up directly and get a bigger bang.
@freemo I wonder if a missile launched from the lunar surface would even get near light speed before crashing into the Earth? Or if the only damage it caused would be no more than a regular old nuke, thus making it not worth the massive expense of building a giant cannon on the moon in the first place? There’s probably an equation that could answer this.