Yes the tranny fluid is red and yes it can leak several times even with the new connectors.

The import thing to understand is one leak can drench the computer above it, and dealers don't check the computer after they repair a leak. The fluid sits on top of and in the computer. Any second leak could help force the problem along also.

just be careful! put in the extra time it takes to check these things out you'll be thankful later