Do automation rules overwrite values that were already set on a ticket?

Your own custom rules do: when a custom rule matches, its action value is applied even if the ticket already had a value for that field. The built-in default rules (like "Default ticket status") only fill a field when it is still empty. Also remember that if several rules try to set the same field, only the first matching rule in the list wins for that field.