Most likely your torq converter is toast and the gear box is full of trash coming from the TC. There is a bearing in the TC, when it breaks it spits shavings int the fluid stream which get stuck in the valve body. At that point the VB stops working as designed and most likely blows a couple of o-rings.

Mine was making a grinding/whining noise and I took it out, refurbed it. Now have 12,000 miles on it and still working.

Good luck on the fix.

__________________
2003 4.4i black ext./black int./black headliner (kid's runabout)
2014 535d X-drive, M package, silver/black interior

Sold but not forgotten:
2009 E70 35d, black ext./black int./black headliner (sold 2021)
2006 4.8iS Le Mans blue/cream int./black headliner, SOLD in 2012 sadly...

Other hardware:
2015 Cayenne S (wife's new DD and definitely wroooommmmm)
2016 Tundra 1794 edition crew cab, luxo hauler
2005 Tundra crew cab, weekend hauler. Sold after 150k very happy miles.