Can a relationship work if you're not attracted to your partner? Can you still be in love with him/her?

i think that there is the very real chance that your partner will look for sex elsewhere if they are not enjoying a satisfying sex life with you.
i have been with my partner for 3 1/2 years. for the first year we had good sex, but i did have to work to get him aroused - unless he'd been drinking in which case he couldn't get enough.
for the last 2 years i have had every excuse under the sun as to why we don't have sex very often. from no bed side tables to tiredness to me being smelly to me not having nice breasts...and it goes on. he used to say i was too demanding if i tried to initiate sex after a few weeks without anything.
my partner watches porn every day for several hours at work (his own boss). he will not share watching porn together and denies he does it!!! he also turns his head and stops talking to watch women walk by.
i find his lies re the porn hurtful because this means we cannot have trust in our relationship because he openly lies to me. it also hurts because he has no desire to share his sexual excitement with me so we can enjoy a sexual relationship together. it hurts because he does not respect me and will openly ogle other women as if i dont matter at all. finally, it hurts because he thinks he can do what he wants behind my back (porn) and just leave me alone and i should be ok with this.
he invited a man we met while out for a drink back to our place. this man was putting his hand up my skirt, grabbing my breasts and bum and talking dirty to me. i told my partner to ask this man to leave and he didnt believe me! he sees me as so unattractive that no man would want me. he said if there really was a problem i should ask him to leave myself.
i used to think i was disgusting for him to react to me this way, but i know he has the issues.
we are still together because he loves me like an angel and looks after me. this sound pathetic but it shows he cares. i gave up my career and moved countries to be with him. i now have nothing and no where to go. we are also expecting our first baby. he will be a great dad.
i have tried talking to him about the lack of sex, lying about the porn, etc. but he either gets angry or lies to me to shut me up. so ive accepted life as it is and carry on- knowing that it may come to the stage when i just cant cope without a sex life(never had one until we met and not my choice to live a life without one).
also due to his treatment of me, i no longer find him sexually desirable and no longer want sex with him - but i long for sex.
now, he is back in touch with the love of his life (before me). he often used to call me her name and compare me to her - she always being the best.
i have a feeling he will go behind my back and begin an affair with her. he finds her sexually attractive and his face lights up when he talks about her. he says they are just catching up by email.
so, i dont think that a relationship without attreaction is a good idea, because there are so many ways in which your partner can be tempted away by the thrill of having something they dont have with you. they may love you for your personality, but in most cases i dont think this is enough and being best friends is not the same as a relatinship.