Yes, the DAO Tiers are your membership level on the Platform and Superfan relates specifically to a project or projects fans are engaged with and supporting.
Fans can have multiple projects where they are Superfans but they will only have on DAO tier ranking per account.