from the video :
you buy a 6Ghz computer
runs 6Ghz for 15s, hits thermal, backs down 5Ghz 4Ghz
cores start to turn off
Well, actually, while my i9-13900HX laptop is limited to 5.4 GHz, not 6, it'll run one compute-bound thread [1] at 5.4 GHz indefinitely.
i dont know why you bought it

A little thing called "Amdahl's law". It's mentioned in the video.
Yup, it can only run all 24 cores at around 3.6 GHz continuously on the parallel parts of the computation, but when you come to the single-threaded parts it makes a significant difference if you can run those parts at 5.4 GHz instead of 3.6 GHz.
Or to look at it from the other angle ... even if you have to back the MHz off 33% going from single-core to 24 cores -- you're still running 24 cores...
I tried a cross-compile of a RISC-V Linux kernel two ways:
17m38.6s taskset -c 8 make // 5.4 GHz all the time
1m27.5s make -j32 // actually throttled back to 3.6 GHz after a while
So an actual speedup of 12x, but 18x compared to if the single-core MHz had been limited to the same 3.6 GHz as all-cores (which would be 26m28s).
Not bad for 8 big P cores and a bunch of small cheap E cores -- as described in the video.
[1] it turns out that on my particular chip, virtual cores 8&9 (the two hyperthreads of one P core) can run continuously at 5.4 GHz, while the other P cores will only do 5.2 GHz continuously. Fun with `taskset` !!