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/8724208087668386529
GitWatcher: ignore
CQ-Do-Not-Cancel-Tryjobs: true
Change-Id: Icce639a72a2802721efb1892bff4ef8fd0e0d85f
Reviewed-on: https://pigweed-review.googlesource.com/c/pigweed/examples/+/263852
Commit-Queue: Pigweed Roller <pigweed-roller@pigweed-service-accounts.iam.gserviceaccount.com>
Lint: Lint 🤖 <android-build-ayeaye@system.gserviceaccount.com>
Bot-Commit: 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