Check out the subreddit https://www.reddit.com/r/DeadBedrooms/.
You'll see a lot of people on both sides of the equation. People who aren't really attracted to their mate but happy in the relationship, and mostly people who are deeply unhappy because their mate doesn't have romantic/sexual feelings for them.
Love is a big term for a wide variety of feelings. It’s an never ending endeavour to explore it.
Romance as such is also different from lust. It is sexual in nature, but with a greater emphasis on the affective than on just sexual attraction on its own. Romance is what people often mean when they say "fall in love". Typically, romance only lasts a couple years, hopefully having gotten the couple far enough to procreate. Of course, it is possible to cultivate romance, but the main point here is that relationships are supposed to mature, and clinging to the pleasure of passing emotions experienced early in the relationship and using that as a standard against which the relationship is constantly measured is a sign of immaturity.
Love is something we often seem incapable of understanding. Love is not an emotion as such, even if lovers experience emotions. Ultimately love is a desiring and a willing of the good. Love can be broadly divided into two basic varieties, namely, the erotic and the agathonic. The erotic (which should not be understoodd as sexual only) is a desire of the good for one's sake. Whenever we desire something for our own good, we are speaking of erotic love. Agathonic love is desiring the good of the other for their sake. A relationship requires both.
I overlooked that aspect for the longest time based on how compatible we were on all other fronts. Unfortunately that turned out to be an expensive and hurtful drawn out lingering issue that exploded down the line.
As Jordan Peterson says, the best, best case scenario is being with a partner you're compatible with and being physically attracted to. Never let go of that person.