SpiritWoman,
Have looked at the chart and from what I can see there is no outright aspect or configuration that would suggest that he is going to have an affair on a continuous basis. Venus and the Sun are his lords, the lords of the 5th house of Leo are the Sun romance-amour' affairs in general, and Libra Venus as a concern about the topic of liaisons or unions, the actual physical relationship. These are areas of the topic you are asking about. Venus is the initiator of both areas of profane and divine love.
His 9th house which now becomes his 5th of unattached relationships or romantic interludes has lords of Jupiter and Saturn/take as the outer's Neptune and Uranus.
The lords of the 5th house the Sun/Venus, (I call them ambassadors) are not to my knowledge making aspects that are forming to planets that would indicate another episode for a romantic attachment, accept, and this is only a sudden interlude if at all, the conjunction that Venus will form with Hershel, or Uranus.
Venus is able to express herself both in Pisces where she is exalted as the one who suffers for someone she loves with unquestionable servitude diminishing her own will to be able to make one happy, or she becomes the brash harlot in expression, not beauteous in form or manner, a fish wife or aggressive individual who knocks over objects of divinity whence she walks. As Venus is in Aries and as she comes closer to the unknown human element Hershel she (the lust nature) makes the advance to satisfy appetites on a casual basis, but Hershel is a malefic so there is always (especially in the masculine sign of brass Aries where he augments additionally his malefic nature) a price to be paid as he is a Karmic/Dharmic planet.
If you are the one whom he (the gentleman) comes home to (the mutual exchange Venus makes with the Sun) suggests he wishes to be with one whom knows his in's and out's of habits and character you have more of a standing with him than the new flame/Aries Venus Sun connection.
The Sun is in his 6th house of health and habits and experiences a moment of release back in Venus Aries-he shines here also with Hershel so it is his ego only that drives his backanaleon fancies, he wishes to shine, in other words it is a tryst he has experienced-(Sun conjunct Neptune and heading for Cheron-reveals his guilt and possible sadness for the character defamation and sorrow he has caused and or has experienced, never realizing liaison's could interfere with where he holds his true love of hearth and herald - his family - you) Do you see the obstacle aspect the Sun is making with Saturn, ruler of his 4th house. His responsibilities are being challenged with this square, he may lose all if he is not careful..Saturn is his family life. Certainly it will (the square) represent strife.
The ambition of Aries where Venus is, is capable of putting higher values aside to gain an advantage of money or prestige, but when in Pisces and she does have the opportunity to reside there in this chart, she dawns the understanding of sorrows that true love needs, that give and take-she is capable of evolving to that pedestal when it is asked of her.
You are Mercury and are moving away from the incident not wishing to be hurt emotionally again, and soon you will move into Aries where you will be able to have an understanding of the energy he wishes to regain, that feeling of being alive and active with the world at his feet for his physical conquest so to speak..the spring of renewal.
Bc you have spoken your heart about the situation (Mercury leaving the combustion of the Sun, being burnt, and leaving the close connection with Neptune, a planet of reflections of sin or sadness) I believe he will not desire to go this route any more.
I am only worried of the approach (Venus will make in the mutual reception position with the Sun) Venus/Sun combination will mean the advent to engage Uranus again. Bc the Sun/and Venus take on each other's effect, even though exalted, Venus going to Hershel will be like the Sun, it will have the effect of some disadvantageous elements to any further trysts, having the effect of a combustion, a burning or diminishing of ardour meeting up with Hershel. The vibration affects your Ascendant, as Aries is a personality (on the 11th hopes and wishes) sign/ house so there will be a skirmish of demands and new attitudes in the wake of these activities. New expectations will be set in order?
The host Mars ambassador of your first house is (has) moving away from this whole business of exposure's, 'get me outta here', (also a male response is that of Mars) (you have moved away from the whole scenario stability Taurus is that which you are looking for.)
Some men have to be reminded that the physical union binds the higher love that lasts in family steadfastness, they are intertwined for any lasting type of love. Is he a flirt by nature. I see the Sun is in Pisces, and here it could represent him. Is he secretive? Does it portray his true temperament?
The thing about common signs is that they are wishy washy, they need direction and are refiners rather than leaders.
Mercury you here, is also in a common sign and is additionally in its detriment; don't be confused about the situation and do make decisions for him to follow. You have him on the run now..I don't think he wishes to move out of the relationship with you but he needs to be perked, to feel alive and sparked. Is he the creative type that needs to be admired for his sensitivities and works?
The indication of emotions you will experience will end in an opposition which I think will mean an ultimatum that you will not be lied to or be deceived again. Moon will square Saturn ruler of his 4th house and his values will be challenged. The Moon rules women's concerns and the feelings, your emotions and your thinking are at odds, Moon opposition Mercury about the destiny of the two of you. It is the last aspect she makes in the chart. Maybe you will just not wish to speak of the eventual separation you and he will agree on. Bc the Moon is involved in the opposition some domestic issues will be separation concerns, maybe you will move, Moon moving into your 4th or it will be the opposite.
I wish I could see it in a different light. The opposition separates those things or ambassadors rights the two planets represent. In the situation here it is the personal 1st house you, your emotions, and the things Mercury represent, communication, contracts rental concerns, (moving etc.) and or getting in contact with each other or making a journey to see each other in the future again.
Wishing you well and safe keeping
All the best
Vyri
P.S. You may PM if you like