No, it is not required to call .Rollback() or .RollbackAsync() if you are disposing of the transaction without committing it.

From the official docs (https://learn.microsoft.com/en-us/ef/core/saving/transactions):

Commit transaction if all commands succeed, transaction will auto-rollback when disposed if either commands fails