The strength of the CPC is for visual...ergonomic from the placement of the handles, you just stick the robot body (fork + tube) on top of the legs and you're good to go. But the fork part is well built, meaning heavy

just the C8 ota alone weighs less than 6kg but the CPC800 is 20kg iirc. It's also bulkier than any single component of the equatorial setup.
The pieces would have are:
- both - tripod
- CPC - fork mount including ota
- HEQ5 - mount head and counterweights
- HEQ5 - C8 optical tube assembly (ota)
There's really not a lot in it, but each component of the HEQ5 setup would be smaller and lighter.
When it comes to long exposures, the difference is in the way the two mounts track. The CPC tracks in altitude and azimuth (vertical and horizontal), which means that as an object moves across the sky because of the rotation of the earth, the object rotates in the eyepiece...this is called field rotation...and it's because the mount is tracking relative to the ground, rather than the sky

in longer exposures, you would see this field rotation as curved star trails.
The HEQ5 - being an equatorial mount - tracks in right ascension (RA) and declination (Dec) which are like longitude and latitude. This means that the mount counteracts (as precisely as possible) the rotation of the earth in the same plane as it is rotating and therefore doesn't suffer from field rotation, and therefore much longer exposures are possible.
One other thing to note about Andromeda....Andromeda is very big relative to many other deep space objects, and you won't get very much of it in the field of view of a C8 because of the focal length of the scope. For large targets such as Andromeda, you need a much shorter focal length scope. Last year I captured Andromeda with my 71mm refractor (focal length ~350mm) and it fit in the FOV nicely.