The implication is that if you start to think that your computer is running low on memory, you can look at the lights to get an overview of what is going on process wise.
Yes. It gives you a rough overview with regard to application processes for GUI apps that are probably taking up most of your memory. Of course, command-Tabbing might be a good alternative, especially if you keep your Dock hidden.