You're right, Terraform is not "write once, deploy infrastructure anywhere" tool. It does however allow you to reuse many portions of your infrastructure descriptions between cloud providers by using module composition[1].

Terraform can also be used to put your infrastructure under version control, which is a pretty big deal.

[1] https://www.terraform.io/docs/language/modules/develop/compo...