I know about the ones at http://ftp.us.debian.org/debian/dists/README, but there are other ones such as:
How many are there? Is there a list somewhere?
You could always use the Debian Sources List Generator to compile a sources list specific to your specific release and branch requirements.
The security repository is segregated for at least one security reason: having security updates in with the other regular package repositories would introduce significant delays (compared to non-mirrored special purpose repos) for people who use mirrors instead of the official repo. By putting security updates in a special repo, and stipulating not to mirror the security repository, people use the security repo directly and don't have to wait for updates to propagate to their local mirror.
As for the other two that you mentioned, I presume their purpose is determinable from their names. Backports is for packages from newer versions which have been backported to older OS versions, and I presume archive is simply that, an archive.