Transports are automatically destroyed only when they are defenseless. This means that something is still shooting at them and they either have no protection or cannot retreat. Attacking transports are very seldom defenseless, as they can usually retreat. See the AAP40 FAQ for further information.
Peck is right. Transports may not unload after retreating.