Google puts that on most of its open source products including both employee personal projects and projects where Google has employees whose job it is to contribute to it.
Yes, for example the Firebase Tools CLI is open source (MIT), but it does not include the waiver, because it is an official Google product: https://github.com/firebase/firebase-tools