Mine does this too, I placed this down to the rear wheels steering a little, so they are slightly working against the turn of the car a bit, as they are not steering to the same degree as the front.
It does seem to be sound louder on sport mode
Personally having had a Tesla 3 performance for a few years which is a quick car did sometimes seem a bit like it’s missing the theatrics of the noise…which the sports sound seems to fill…. Surprisingly.
Akin to watching an explosion, or a rocket...