So, long story short, the sound was coming from the windshield wipers and the leak was coming from behind the taillight. They replaced both and it fixed the issues.
As a side note, I had two loaner vehicles during this process and they made me miss my car so much. The 2017 model X 75d and 2016 model s p90d are both so outdated compared to my 2022 Y. They both rattled so much and had such slow and unresponsive voice controls. Both if them had lots of wind noise as well. The sun visor on the model x is a ridiculous design. Even the seats in the older x and s are so inferior to the current Y. Tesla has certainly come a long way in 5 years.
As a side note, I had two loaner vehicles during this process and they made me miss my car so much. The 2017 model X 75d and 2016 model s p90d are both so outdated compared to my 2022 Y. They both rattled so much and had such slow and unresponsive voice controls. Both if them had lots of wind noise as well. The sun visor on the model x is a ridiculous design. Even the seats in the older x and s are so inferior to the current Y. Tesla has certainly come a long way in 5 years.