Lets understand this stuff in scientific and medical terms.
Practicing meditation can affect levels of neurotransmitters in our brains, like dopamine, now dopamine’s one of the main jobs is to regulate our sexual urges.
It is very common for people who meditate regularly to be affected by sexual thoughts, urges, or even orgasm while praying or meditating. Biologically speaking, your dopamine level probably has been increasing, especially if you are going deeper with your meditation.
Having said that, mankind from millions of years has been sexually repressed, sexual desires in one way or other has been stuffed deep down in human subconsciousness since millenia.
This very idea of repressed subconsciousness was difficult to conceive or understand by Orthodox, the conservative or the holy men’s and as there was not much understanding of advance psychology or psychiatrist in early ages, the holy lot got freaked out by manifestation of stuff repressed in basement of their subconsciousness and thus they created fictions like Succubus and Incubus.
In folklore traced back to medieval legend, a succubus (plural succubi) is a female demon or supernatural entity that appears in dreams, who takes the form of a human woman in order to seduce men, usually through sexual intercourse. The male counterpart is the incubus. Religious traditions hold that repeated intercourse with a succubus may result in the deterioration of health or even death.
In modern fictional representations, a succubus may or may not appear in dreams and is often depicted as a highly attractive seductress or enchantress; whereas, in the past, succubi were generally depicted as frightening and demonic.