The SET TRANSACTION command sets the characteristics of the current transaction. It has no effect on any subsequent transactions. SET SESSION CHARACTERISTICS sets the default transaction characteristics for subsequent transactions of a session
In practical usage, I rarely use SET SESSION, I prefer to set it at the transaction level.
For your demo, try also examining SHOW default_transaction_isolation;
