If a wire shorts to the waterline it will carry fault current back to the service to clear the fault. The code making panels recognize that a ground rod or Ufer ground will not and cannot carry enough current to clear a fault so there is no reason for the conductors to be sized to carry fault current.
It is only likely to do that where there are other services also bonded to same metallic water piping, otherwise the actual resistance of the water piping is not really known, what if there is only the minimum of 10 feet of metal piping that is required to call it an electrode? In that case a CEE just may have less resistance, two ground rods may even have less resistance.
Building steel that qualifies as a grounding electode is also required to have a GEC sized to table 260.66 and not just water piping.
250.66 (A)(B)and(C) are the exceptions to using the sizes in the table, rod, pipe and plate electrodes don't need a conductor larger than 6AWG copper, CEE don't need a copper conductor larger than 4 AWG and ground rings don't need a conductor larger than the conductor used for the ring. All other GEC are sized to the table.