Earlier quoted context omitted.
Cable weight corresponds to charging power rating and choice of materials, not plug choice. A combined CCS2 plug is chunkier and might be a bit heavier, but not compared to, say, using a fuel pump.
Just go try them both. CCS2 Has separate AC and DC conductors, and the plug is huge owing to having 2 pair of charging pins and backward compatibility. They are more awkward and heavier than a fuel pump, and significantly heavier than the Tesla plugs. It's terrible.
I have to admit I haven't used Tesla plugs, but there is already a slight difference between the cable from a 50kW charger and a 350kW charger.