A keyring is a "stored database" -- I'm using this term lightly -- of your login information stored on your local PC. It's wrapped by some magic voodoo encryption schema (PKCS#11 - this is used for secure storage on removeable media) so its going to be relatively secure from prying eyes.
Its providing a common backend for (insert framework here, we will use gnome for an example) to CRUD (create, read, update, delete) your login information without "rolling your own solution". It keeps a consistent interface for programmers utilizing that particular framework. KDE provides its own keyring, Gnome has another implementation of it.
Evolution, Firefox, Net-man all utilize this interface. When you place your email server credentials into Evolution it asks you to store that information in the keyring. If you opt into it, it passes the data off to the keyring service and voilà its stored. Evolution only has to subsequently call the keyring service on startup to retrieve that information.
The big idea here, is that if someone else were to access your PC, and did not know the master password to your keyring, they could not access your stored login information. The same principal is put to use by lastpass.com's addon for your browser. (only it's distributed, meaning I can use it on several instances of browsers across PC's)
In summation, I offer this snippet from the gnome-keyring page located here
GNOME Keyring is a collection of components in GNOME that store
secrets, passwords, keys, certificates and make them available to
GNOME Keyring is integrated with the user's login, so that their
secret storage can be unlocked when the user logins into their
GNOME Keyring is based around a standard called PKCS#11, which is a
standard way for applications to manage certificates and keys on smart
cards or secure storage.