All the answers on that post are good for normal uses.
Godot CCD works with small objects at around 10k units/s which is really high (ray based CCD gives incorrect results but the collision point is the same as shape).
If you want insane speeds then you will have to make your own CCD technique, Godot offers many tools to do your own physics.
Why objects shoot through colliders? because of tunneling.