If you describe someone as moody, you mean that their feelings and behaviour change frequently, and in particular that they often become depressed or angry without any warning.

If you describe a picture, film, or piece of music as moody, you mean that it suggests particular emotions, especially sad ones.