You have a leak between the rad and tranny cooler, you’ll need to replace the rad at the very least.
You’ll also need to drain and flush the tranny and replace the tranny filter. You might be lucky and get away with just that.
Worst case, water has blown the tranny valve block seals ~ that’s probably a new tranny.