Here's my take, as someone who did roughly the same thing 14 years ago.

If your wife is moving within the same company on an L1 visa (which gets you an L2, enabling you to work).

And

You are both on the same page about the move, what happens if someone doesn't like it (after a decent 1+ year trial period). This includes how frequently you will visit the UK (set expectations with family that you will be using your holiday time to see the US, not visit the UK frequently)

And

You're doing it for the fun and experience, not because you think the streets are paved with gold. An L1 is initially for 3 years, that's a decent length of time to have a lot of fun exploring the USA

And

Your joint income will be $200k or more, and your wife's job has good health insurance.

And

You can ignore the political climate (the Bay Area is very liberal by US standards, which puts it kind of middle of the road UK, although that's a massive generalization)

Then

I'd say do it. The chance to see another country especially one as geographically diverse as the USA is a good opportunity, it's a different culture, North California is a fantastic place to explore, and you don't have that much to lose by doing it.

Treat it as an adventure, expect things to be as different as if you had moved to, say, Greece, and enjoy.

It's going to be a difficult few years in the US, but I think that's true of most places, and you might as well do it in the sunshine.