roll: third_party/pigweed bazel: Get googletest from BCR

Most of the work here is actually moving the Fuchsia SDK dependency from
WORKSPACE to MODULE.bazel, so that we can tell googletest to use the
real Fuchsia SDK instead of the fake one googletest ships with.

Fixes: 384999150
Fixes: 354268150
Original-Reviewed-on: https://pigweed-review.googlesource.com/c/pigweed/pigweed/+/255873
Presubmit-Verified: CQ Bot Account <pigweed-scoped@luci-project-accounts.iam.gserviceaccount.com>
Original-Revision: 5508852ae65fa08ef545f57e0eb728f626fe2524

Rolled-Repo: https://pigweed.googlesource.com/pigweed/pigweed
Rolled-Commits: 95129869708a65..5508852ae65fa0
Roll-Count: 1
Roller-URL: https://cr-buildbucket.appspot.com/build/8724203954667664257
GitWatcher: ignore
CQ-Do-Not-Cancel-Tryjobs: true
Change-Id: I5b34a5aefdcbf72c5f7a43e146507e71d0233fbd
Reviewed-on: https://pigweed-review.googlesource.com/c/pigweed/experimental/+/263892
Lint: Lint 🤖 <android-build-ayeaye@system.gserviceaccount.com>
Bot-Commit: Pigweed Roller <pigweed-roller@pigweed-service-accounts.iam.gserviceaccount.com>
Commit-Queue: Pigweed Roller <pigweed-roller@pigweed-service-accounts.iam.gserviceaccount.com>
diff --git a/third_party/pigweed b/third_party/pigweed
index 9512986..5508852 160000
--- a/third_party/pigweed
+++ b/third_party/pigweed
@@ -1 +1 @@
-Subproject commit 95129869708a65d9ced12887af9da34e422f9808
+Subproject commit 5508852ae65fa08ef545f57e0eb728f626fe2524