Even worse than the TDP was the fact that the 90 nm Pentium 4 had huge leakage current, so its idle power consumption was about half of the maximum power consumption, e.g. in the range 50 to 60 W for the CPU alone.
Moreover, at that time (2004) the cooler makers were not prepared for such a jump in the idle power consumption and maximum power consumption, so the only coolers available for Pentium 4 were extremely noisy when used with 90 nm Pentium 4 CPUs.
I remember when at the company where I worked, where we had a great number of older Pentium 4 CPUs, which were acceptable, we got a few upgrades with new Prescott Pentium 4. The noise, even when the computers were completely idle, was tremendous. We could not stand it, so we have returned the computers to the vendor.
Some coolers today still look like that but they're on chips drawing 35W or so while idling at <2W.
[1]: https://www.cpubenchmark.net/cpu.php?cpu=Apple+A18+Pro&id=62...
[2]: https://www.cpubenchmark.net/cpu.php?cpu=Intel+Pentium+4+3.7...