Not sure yet if I have coolant in my transmission fluid but it was awfully watery in consistency toward the end of draining it. If I indeed do have coolant in my transmission that would likely mean my water pump seal is bad correct? Is there anything else it could potentially be I'm not thinking of? Thanks for any input.

If the water pump seal is bad it will leak out of the weep hole.  If someone plugged the weep hole and the water pump seal is leaking, water will be forced into the transmission.  A bad clutch cover gasket can also put coolant into the transmission.  A crack in the clutch cover in the water pump area will also put coolant into the transmission.