The email_templates_default table names the known templates within the system. The email_templates_default_data table provides contents for those templates by locale.
The email_templates table names templates which have been overridden from their default within the system. The email_templates_data table provides the contexts for those templates by locale.