Physical attractiveness DOES matter

I'm starting to not understand people who say that the other person's physical appearance shouldn't matter to you when choosing to be in a relationship, and that personality is all that should matter, otherwise you're shallow. For more than 1.5 years I was with someone who I didn't find sexy or attractive. Guess what happened when the pink cloud disappeared? Intimacy felt like a chore. It was something I just wanted to get over with, I didn't enjoy it and didn't initiate as I simply didn't find my s/o desirable.

Now what is attractive and what isn't - obviously - depends on each individual. Even if you're not conventionally attractive, doesn't mean someone out there won't be crazy about your body. But if sex is something that you want to be a part of your relationship, you should look for your own definition of a hot person, someone who you desire to be with.

Edit: wow thanks for all these comments, I never expected to have so many. Multiple people mentioned that they feel physical attraction due to the emotional bond they have to their partner. How is that different from a friendship then? With some friends I also share a deep emotional bond but still don't want to have sex with them. When a crush becomes a relationship, it works like that for a while but of course the crush/pink glasses stage is over after a while. After that, how is the bond different from a friendship?