A metal pipe coming out of the ground is at a potential.
The earth coming into your house may be at a different potential.
If these are not bonded together then there may be a potential between them which would be dangerous.
That is why bonding is carried out, and that is why it is done as close to the point of entry to your property as possible.
Yes, agreed, and for a TN-S or TN-C-S system, it certainly makes sense to achieve as good (low impedance) as possible bonding to supply pipes as close as possible to their entry into the property; with such systems, it is extremely unlikely that the supply pipes would be introducing a potential other than earth potential, whereas the DNO's terminal could, under fault conditions, be at almost any potential - hence possibly very different from the earth potential introduced by the supply pipes. Two points arise:
Firstly, if one accepts that "it ... makes sense to achieve as good (low impedance) as possible bonding to supply pipes as close as possible to their entry into the property", then the sort of multiple connections to the supply pipes I was talking about could, in fact, be advantageous (i.e. theoretically safer). That is particularly true of an installation like mine. There is a 10mm² MPB cable travelling to a bonding point close to the entry point of the supply - and I accept that to be necessary just in case someone cuts the pipe or replaces it with plastic. However, the fact is that, in order to get to that bonding point, the MPB cable travels several metres alongside the (22mm) pipe to which it is ultimately bonded. Given that the effective copper csa of 22mm (0.9mm wall thickness) is around 30.5 mm² (i.e. much larger than the MPB cable), the impedance of the bonding would (so long as the pipework remains intact) be lower if the MPB was additionally bonded to the pipe at the first point the cable and pipe meet.
Secondly, I forgot to mention that I have a TT system, and I find more difficult to understand the concept of MPB with such a system. With such a system, it would require pretty extraordinary circumstances for either the supply pipes or the earth electrode/conductor to introduce any potential other than earth - which seems to make it less obvious why one needs to bond them together with a cable - but, even accepting that as a 'just in case' requirement, it is again not obvious (at least, not to me) as to the basis one would use if attempting to determine (from first principles) an appropriate sizing for the MPB conductor. I accept that TT systems often get changed to other systems - but if that happens, the whole bonding situatiion needs to be reviewed, anyway.
Kind Regards, John.