Ah!, learn something new everyday :P.

That's a good it depends. There would need to have a buttload of traffic on that table to cause tempdb to crash or become a hotspot (unless it's already hot and getting worse because of that).

P.S. Just remember to deactivate the trigger before doing your big table load... that could really make a hot-spot of the server!