There’s no ‘ cancel out’ there would be a violent kinetic reaction as all the energy is released when the cannonballs collide. Depending on the muzzle velocity you would get something between smushed cannonballs to a massive expanding sphere of iron shrapnel and slag, assuming they were aligned perfectly.