It's not just a one-time use thing. If you have the Great Wall, and it hasn't been made obsolete yet, then nobody can declare war on you. When playing single player on the highest difficulties, it can be a total lifesaver, as the AI loves to declare war at the drop of a hat.