Citi, for example, will not transfer a call to the retention department if the system shows that there is no offer available for the specific account. It could be that the Amex agent made a mistake, and there was no offer. It's possible that the retention algorithm predicted that an account of that age (amongst other factors) was unlikely to be cancelled.
Amex tries to connect you with the retention department regardless of offer