Please do not take me wrong, I do not want to discover that the earth is round but is something that is missing.

You say that when:
create table as select * from table@remote has nothing to do with the rollback seg.
I think there is an “insert “ involved in this create table so there is a transaction.
How the data is “moved” into a new table?

thanks