"...to launch cargo out of Earth's orbit and have it reach the Moon"?
Oh heavens no, definitely not. Let's do some quick back of the napkin math:
It takes about $7.8 km/s$ to reach Low Earth Orbit, and around $11 km/s$ for a Trans Lunar Injection.
The Shuttle takes about 8 minutes to reach LEO velocity.
Meaning, it spreads out the $7.8 km/s$ velocity change over 480 seconds.
$1g = 9.8m/s^2$
So,
$G-force = \frac{\text{Acceleration in }m/s^2}{9.8}$
So, the Shuttle's acceleration $= \frac{\text{7800 }m/s}{480\text{ seconds}} = 16.25$
and $\frac{16.25}{9.8} = 1.65g$
So, very roughly, on average, the Shuttle's acceleration over time is 1.65g.
Now an artillery projectile does not contain its own propellant, so it is not accelerating after it leaves the barrel. It gains all its velocity at once in the beginning, meaning this cannon/catapult/trebuchet must impart $11 km/s$ $\Delta v$ instantaneously.
$\Delta v$ = literally, change in velocity
Lets round up and say this cannon imparts this velocity change over 1 second exactly, instead of milliseconds.
Projectile's acceleration $= \frac{\text{11000 }m/s}{1\text{ second}} = 11000$
$\frac{11000}{9.8} = 1122.44g$ = LOL
What about just getting to orbit?
$\frac{7800}{9.8} = 795g$
Pretty safe to say just by looking at the numbers, doing some quick rough estimates, it's never going to happen.
The problem you see with g-force is the time over which you accelerate. Acceleration says low as long as you take longer time to reach your desired speed. (In this case, orbital or TLI velocity.)
You can experience this directly in your car: accelerate from 0 mph to 50 mph pushing the pedal as hard as you can. You will reach your desired speed rather quickly, but will feel more acceleration forces on your body as you go.
Press the pedal lightly from 0 to 50 mph, and you will eventually reach the same target speed over a greater period of time, and thus feel much less acceleration.
So the problem with the orbital cannon is two-fold, and likely why one was attempted but never built: 1) it can only impart change in velocity once, at the beginning 2) orbital velocity is so great (never mind TLI right now) that nothing hollow could survive the g-forces. (Seriously, you might even flatten a solid piece of steel.)