It's a community repository for Fedora. It works similar to RPMFusion: you can use it along the official repositories to grab software that's not available there. If you'd like to reduce the number of organizations you're directly depending on, you may choose to use their Fedora fork, with their own repositories (forked from Fedora's), called Ultramarine Linux [0].

[0]: https://ultramarine-linux.org/

Rawhide is the development branch of Fedora. Terra is a community rolling-release repository that provides additional software on top of Fedora, for both the Rawhide and stable versions of Fedora. They're not directly comparable.

Sure they are. Rawhide is the official community-driven rolling release for the latest of Fedora. If you want to get some package into Fedora (and thus RHEL), put it into Rawhide, not Terra.