I wonder if it's the same noise I'm annoyed about (the 2nd noise in my video below)? What's most annoying is that I bought a Model Y for car camping - and when I park, I can hear a permanent buzzing noise from below the MCU - sounds like speaker interference - it's at 370Hz frequency.
But also there's also another pulsing fan/pump noise that is permanently audible (180Hz when the car is awake, drops to 150Hz when I put it into "Power Off" state). No AC running, and the car has been parked for an hour.
Both of these would prevent me from falling asleep.
It's currently in service with Tesla for these noise issues, and I've made this video to help them diagnose.
If anyone has any further input, it would be greatly appreciated!