If your torque converter is fine, and the noise happens only when the torque converter is connected to the to the flex plate and it is regardless of whether the vehicle is moving or not, then it seems like:
- something that rotates with input transmission shaft is making noise. If you are in PARK, AFAIK, only the shaft and the oil pump would spin. In 42RLE the oil pump is spinning regardless of the PARK, as it is connected to the input shaft. If the noise happens when you are in DRIVE, but sit on brakes, the then no planetary is supposed to spin, only the oil pump is supposed to continue spinning.
So, it could be that your oil pump went bad. You can replace the oil pump, it is in the bell housing. Not too complicated. I would do this job myself, if would have enough time for this.
Remove the transmission, remove the torque converter, replace the oil pump, reinstall the torque converter and then install the entire thing back into the rig. If you are at it, and pull the transmission out, then replace the oil filter, valve body and the solenoid pack as well, and add oil pan temp sensor for sake of long term reliability. Also, it might be a good idea to drop a new torque converter, if you can find good and cheap one.