Sadly this won't happen in the US. Even if it's really private, people won't install it unless it's pushed down to them as an update from above, and no company will want to be the first to push it.

I suspect the bigger issue is people don't want to be told by an app that they need to go get tested.

Come to think of it, cities like New York could push it as part of a bigger, more comprehensive covid app...