would we ever see rockets launched from Moon or low Earth orbit?

You need the rocket to get to LEO or the moon. Once you're actually in LEO your propulsion system needs relatively little thrust, but you've replaced a moderately hard problem of launching from earth with a much bigger one of assembling things in orbit using material that's already there...