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.
Bosch Master, ASE Master, L1
33 years MB technician