How long will a 2002 Honda accord last with a transmission leak?

Indefinitely. Longer if you get the leak fixed sooner than later and never let the fluid level get too low.