Generally, it relates to very strong emotions, both sexual and non-sexual. I'm not sure why you think there is a lot of subtlety here.Have you found a variety of contexts that puzzle you? What are they?
I would like to know the many connotations for "Being Passionate". Can any one give me the exact meaning.
I think that for most words, "many connotations" and "exact meaning" are mutually exclusive. If a word has many connotations, it is not easy to give its exact meaning without a specific context.