Ultimately Shannon tells you how much data you can get down a length of cable. What is often missed is that the information rate is governed by two things, not one. The bandwidth of the channel and its signal to noise.
In the real world with lengths of cable, the two metrics are somewhat intertwined, as there is no single figure of merit for either, rather the signal loss depends upon frequency, and the signal to noise is related in-part to the signal loss, and there is no hard cut-off, rather a frequency dependant loss.
Noise comes in the form of intrinsic noise in the system (thermal etc) and external interference.
Managing these, is the cornerstone of how we get serious data rates.
Coax versus twisted pair isn’t a simple answer, both have advantages and disadvantages. Coax has the advantage that it is self shielding to some extent. That means it tends to have better signal to noise than twisted pair. A perfect twisted pair can reject common mode noise, but this is limited by real world constraints in manufacturing tolerances and proximity to sources of interference. It is also limited by the ability of the receiver electronics to reject common mode noise.
In long cable runs you run into problems with impedance mismatches. These can come about due to jointing the cables, or from mechanical distortion of the cable. A mismatch causes reflections of the signal, and this ends up looking like even more interference - so the signal to noise drops - and so does your information rate. The massive hike in data rates over twisted pair cables - whether Ethernet or DSL cabling is mainly down to insane levels of signal processing that dynamically characterises the cable run, identifies the impedance glitches present, and creates an appropriate convolution for a DSP engine to use to ameliorate the cable imperfections. This is close to science fiction for those of us that grew up screwing 10-Base-2 vampire taps onto coax as thick as your thumb.
ADSL won big by dynamically characterising the interference it is seeing (and because it shares a multicore cable with all your neighbour’s signals, it sees a lot of interference.) By looking for frequency slots with less interference, and ignoring slots with more, it can pick and choose the total bandwidth, and optimise itself to only use the good bits, and not be hamstrung by the noisy bits. This trick is not restricted to ADSL. (The reason ADSL is Asymetric is because when all the cables come together at the exchange - in the DSLAM - there is a huge amount of noise from all the signals being sent out to all the customers. So signals coming into the DSLAM from customers, already attenuated because they have come the full length of the cable, arrive to be presented with maximum interference - so the signal to noise for data going upstream is bad, whilst data ravelling downstream is received by the customer in comparative quiet at the home, and much better signal to noise is found, allowing much better data rates.)
The point? Coax versus twisted pair isn’t a direct determinant of what can be delivered. Assuming it isn’t badly degraded due to its age, coax, in general, will have both significantly greater bandwidth and better signal to noise, and if you had a private connection you could see insane data rates. The fact that it has to be shared is where you see a drop in real life use. But given most people are not slurping constant high data rates, and most use is highly peaky, you can get a lot of happy customers on a shared resource. High resolution movie on demand streaming is the elephant in the room here.
Here in Oz there was a bit of a scandal when the coax infrastructure of one of our telcos was purchased with the intend of being used for providing high speed internet reticulation, but proved o be in such poor shape that the entire investment was written off, and roll out of services in quite substantial fraction of the country delayed by over a year.
Most people I know who have HFC (Hybrid fibre coax, where coax is used to provide the last mile reticulation) are pretty happy. I have fibre that terminates in a pit outside my house and the last few metres comes in over the old phone pair. I get a real 80M/s down and 40Mb/s up. But those on HFC can get comparable speeds.