No, Eros is not as significant as a (personal) planet would be. Unless it's just for a one-night stand.
Eros represents the general erotic principle, but Mars and Venus (and Moon and Pluto) all play much bigger roles in the realm of sex/erotica. My advice would be to not worry too much about Eros (or other asteroids, with the exception of Chiron) until you've more or less figured out the interplay of the planets.