The main reason that the Moon is seen as dangerous and negative only is that in the average spread, there will be few uses for a card signifying imagination, dreams and intuition and more for self-deception, illusion and deception in general. You don't need to look out for imagination and dreams, the focus is on what might be dangerous and the Moon gets the short end of the stick because of that.
Eve was deceived herself by the snake, she didn't deceive Adam. Any story that portrays women as deceitful and potentially dangerous is nonsense and I certainly don't ascribe to Abrahamic mythology that includes notions like those. This particular myth, meant to explain human mortality ends up blaming women which is incredibly vile and a huge distortion on the Middle-Eastern mythological background it's based on.
In any case, that has nothing to do with the Moon as I see it. The Triple-formed Hecate rules over the night, the Moon, spirits of the dead and necromancy, magic. Not just as a domain ruler but a protector from them as well. Artemis the Moon goddess was famous for bringing swift, sudden death to women but she is also a goddess that protects motherhood and birth. She's also very famous for killing rapists. Accordingly, her twin brother Apollo can bring swift, sudden death to men, despite being the Sun god. Persephone might be the wife of Hades-Pluto and Queen of the underworld but she also rules earthly wealth and takes pity on lovers separated by death. (Selene, Artemis and Persephone being all faces of the Moon, Hecate the triple-formed)
What does all that mean? That the Moon has power and that feminine passivity does not mean weakness, you can very easily drown in a perfectly calm lake just like you can wither and die in a desert. But recognising that power is no reason to act insecurely and fear it or label it as all negative. It should command respect and appreciation. Lose that nuanced duality of the feminine (same as the masculine) and you end up getting paranoid of witches gathering at night (remnants of Hecatean rituals probably) and organising inquisitions to weed them out.