Even if the password leaks, nobody can log in without the second factor. Hardware keys and code-generating apps are best; SMS codes are convenient but weaker. For a website administrator's account, it is one of the cheapest and most effective safeguards.
In practice: Guide: how to secure WordPress, including two-factor login