It had its pros and cons with her. It definitely helped to soften her as a person. She is so much more vulnerable than she used to be and so much more tolerant of situations beyond her control. I think both motherhood and Kabbalah led to that. I think she gave them free publicity at the beginning because it also gave her publicity. It helped fuel her Eastern spiritual image for Ray of Light, but got cloying by the time we reached American Life, where she wove Kabbalah concepts into many of her lyrics.
The problem I had with this is a lot of things that were revelations for her were just common sense for most people (i.e. "I learned it's about how you treat people", light = good, darkness = bad, calling herself stupid in a song to people who idolize her was never going to be popular). We also have to remember Madonna's upbringing , which caused her to have a lot of the personality deficiencies that caused these simple concepts to be revelations to her. She only had one parent, and then a new step-parent as a teenager. That one parent worked and was spread out between 5 and then 8 children, so I'm sure being loud, brash, and rebellious were things that very naturally came to Madonna, whereas those are not common characteristics among the general populace.
But hey, she always said she would be a nun or a teacher if she didn't become a pop star, and her Kaballah phase kind of allowed her to live both of those out.