Given a first-order language $L$ and a theory $T$ in that language (a set of formulas of $L$), if $T$ is strong enough to prove arithmetic, then Gödel's second incompleteness theorem tells us that $T$ cannot prove its own consitency, ie $T\not\vdash \text{Cons}(T)$.
Now, imagine for a second that Gödel's second incompleteness theorem is false, and that we do have a formal proof that $T\vdash \text{Cons}(T)$. What confidence does it give us in $T$ ? If $T$ is inconsistent, it proves all formulas and in particular $T\vdash \text{Cons}(T)$. That makes this imaginary proof of $T\vdash \text{Cons}(T)$ fundamentally useless.
So if I rephrase Gödel's theorem tongue-in-cheek, it reads : do not look for a useless proof of consistency, because apart from being useless, it is nonexistent.
Then what makes the incompleteness theorem so famous ? It halted Hilbert's program, but I fail to pinpoint exactly what Hilbert hoped to achieve.