Some auto tranny fluids will start to flash in the low-to-mid 300°F range, typically most by 350°F. Synthetics usually are safe above 400°F. ATF datasheets spec viscosity at 100°C. I guess the warning light really is a warning light, so if it comes on you are taking a ride in the danger zone and like Steve says, flush and fill would be wise because you might be cooking the lube.
'91 Pickup - Imelda
'08 Tacoma TRD
'09 Kawasaki KLR650
'12 Gunnar Rockhound 29
"To live is to suffer, to survive is to find some meaning in the suffering." -- Friedrich Nietzsche