There is no transaction, according to the question. You are coming into the trigger without being in the context of a transaction. In other words, there was no "begin transaction" executed anywhere before the trigger started.

No transaction = no rollback.