The tranny temp will effectively increase the same amount as the increase in stall speed. For example, if you increase the stall sped by 3x (as you are) so will the heat generated by the torque converter. Especially if you actually use your truck on the street, where the typical RPM's are less than 3k, and you're moving such a heavy vehicle.
The things to consider when picking a stall speed are: average rpm during use, weight of vehicle, and low-end torque.
Since the average RPM of a street vehicle is less than 2000, the converter will be constantly slipping - creating HUGE amounts of heat.
The weight of an Explorer is well in excess of 4000lbs, creating more heat during accleration.
The Explorer does not product much low-end torque. Increasing cam size will only lower the low-end torque. This will reduce the power to slip the converter. This will make it harder to create heat.
My advice? don't upgrade the converter unless you're only drag racing it, or work in a tranny shop (if you did, you wouldn't be upgrading the converter). If you do get the converter, get the biggest **** trans cooler you can fit, and install a trans gauge. Anything over 200*F is hot for a trans - more-so if you're putting power through it. A trans temp gauge is necessary.
Other things to consider: Most aftermarket converters are not compatable with electronic transmissions because they can't "lock" for 3rd and 4th gears. The ones i've seen that ARE compatable are well over $500.
High-stall converters installed in street vehicles will reduce gas mileage because of the increased slippage.
Keep in mind that a larger camshaft might have problems producing vacume at idle because of the lack of compression the stock (9.0:1) engine produces. This will affect your power brakes, MAF, and emissions.
Alternatives? For the same price, try changing the gear ratios of the diff's. You could have the front AND rear changed for less than $800.
For more money, use a built Mustang AODE-2 trans. The trans is identical, but the gear ratios are closer together and will take advantage of the higher RPM HP you'll be producing.
Good luck!
-Brad