I have a 2014 P85 MS. It began making that loud sound during super charging at about year 6. It does get quieter if I turn off the AC inside the car while it's charging.
I took the car to Tesla service multiple times to listen and tell me if there was a problem and they said it was a normal...