Transmissions don't usually make noises and work. They make many sounds that are appropriate but sounding like a wheel bearing is not likely. It is likely that the trans mount is bad and with the trans sitting on the crossmember it might sound like a wheel bearing.

__________________
Steve Brotherton
Continental Imports
Gainesville FL
Bosch Master, ASE Master, L1
33 years MB technician