Google Cloud Serverless `google-cloud-http.test.ts` does not work in Node 24

[AbhiPrasad]

Description

ref #16236 (comment)

When upgrading CI to account for Node 24, the Google Cloud Serverless Node 24 Unit Tests fail: https://github.com/getsentry/sentry-javascript/actions/runs/14913821156/job/41895096782?pr=16236

⎯⎯⎯⎯⎯⎯ Failed Suites 1 ⎯⎯⎯⎯⎯⎯⎯

 FAIL  test/integrations/google-cloud-http.test.ts [ test/integrations/google-cloud-http.test.ts ]
TypeError: Cannot read properties of undefined (reading 'prototype')
 ❯ Object.<anonymous> ../../node_modules/buffer-equal-constant-time/index.js:37:35
 ❯ Object.<anonymous> ../../node_modules/jwa/index.js:1:19

⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯[1/1]⎯

 Test Files  1 failed | 5 passed (6)
      Tests  31 passed (31)
   Start at  19:01:43
   Duration  3.99s (transform 1.32s, setup 0ms, collect 7.68s, tests 151ms, environment 2ms, prepare 787ms)

We need to fix this and re-enable google cloud serverless:

sentry-javascript/scripts/ci-unit-tests.ts

Line 32 in 5dd37a6

const SKIP_NODE_24_PACKAGES = ['@sentry/google-cloud-serverless'];

[AbhiPrasad]

This was because of a Node 24 breaking change https://github.com/nodejs/node/releases/tag/v24.0.1 - we can remove this now.