I had to look it up, the Carrington Event was a solar flare that impacted the entire globe and caused telegraph stations to set on fire in the 1800s. It's the biggest magnetic storm in recorded history, and would lead to global devastation if another one that size impacted Earth due to our reliance on electronics
if you watched the video, your last point seems to be demonstrably untrue, as what hit us this week, the video author is saying, was the same size and category 5 solar emission that The Carrington Event was, and we didn't experience any disruption to our satelites, or electrical grid at all, probably because we were prepared for it, which is as interesting as it gets
Just like all storms, the geomagnetic storm scale is imperfect. It maxes out at G5, so it's possible for a substantially worse storm to be in the same category as what we saw last weekend.
The 2003 event produced the biggest-ever solar flare ever measured, an X45. That year, several BIG transformers exploded in South Africa. This event's biggest so is 8.7. A lot depends on where it's aimed at ... but anyway , no, we are not prepared.
I know nothing about how any of this works, and so what I am gonna say may be complete nonsense, but If the current one was weaker and the last powerful one was in the late 19th century, then this would hopefully means another "real" corrignton event will at least need more than a century and half to occur.
Unfortunately for us, the sun isn't an egg timer, and it's pretty much completely impossible to determine exactly when and how strong the next solar flare is until it's hurtling through space and potentially in our direction (beyond general trends like solar cycles and such). Would be great if it worked like that though.