Hi Mark
I can confirm you’re not the only one – I have exactly the same issue on my 2019 Audi A6 C8 Avant.
In my case the water ingress occurs in the same area you’ve highlighted, although on my car it is under the front passenger seat, as we have left-hand drive cars in Italy, while UK cars are right-hand drive.
For now, I’ve lifted the carpet and dried as much water as possible – and there was a huge amount of water trapped in the foam. Out of curiosity I also lifted the carpet on the opposite side, which is completely dry.
Previously, I had also come across the Audi of America TSB, so I decided to check whether the longitudinal chassis member (longeron) was holding water. I removed the sealing plugs on both sides: the side affected by the leak was completely full of water, while the opposite side was totally dry.
At the moment everything has been dried out, and I’m now looking for a more permanent solution to prevent this from happening again. Apologies if the translation isn’t perfect – English isn’t my first language.