Automatic Transmission Cooler problems of the 2006 Honda Pilot

On 01//10/13 I was driving my 2006 Honda Pilot, and heard really bad noise coming from under the hood. My car slowed down and I barely made it home. Upon arrival home, we checked transmission fluid and found it to be nonexistent. In the morning we added some transmission fluid and with great difficulties I took my car to a dealership. Service department got back to me with the results of testing telling that they got two readings on the computer: internal transmission failure and catalytic converter failure. I took it to another transmission shop. They have taken transmission apart and declared catastrophic failure. ?initial inspection of vehicles transmission found extremely audible ?grinding? noises from vehicles transmission in park & neutral positions. Also, delayed engagement in drive & reverse positions. Vehicles transmission fluid level was good but fluid condition was extremely overheated and very dark in color. (this is an added fluid on the day I took it to a dealership ) upon transmission removal, disassembly & internal inspection, abc found transmissions main input shaft bearing failed catastrophically and spread ball bearings and metal debris throughout the entire transmission causing damage to many internal components including the transmissions case(s), torque converter & cooling system. This transmission is not able to be economically rebuilt due to the severe damage to the case(s) and major internal components. I don?t know if transmission had some internal defect from the beginning or failure happened later on, but I do believe that such a massive damage to my transmission parts could?ve been avoided or minimize should service department been more diligent in their maintenance process and should Honda be more upfront about continues problems their transmissions exhibit.