No, you don't need to base your Instagram captions on your moods. However, you can use your moods to help you develop ideas for your caption.
For example, if you're feeling happy, you could write a caption about how happy you are. If you're feeling sad, you could write a caption about how you're feeling.
Either way, using your mood as inspiration can help you write a good caption.