Sometimes the lack of initial attractions works, but not usually. I've known people who were not initially attracted to their partners, but who had reached a point in their lives when they truly became more interested in having a long term commitment that would provide them with a general sense of well being and security. These people I know personally, and they have been successfully married for many years, having developed a partnership.
However, I have a feeling that you may be a more passionate person......and there is nothing wrong with that. Personally, when the flame of desire was not there for me, I have always kept the relationship platonic. I have to feel desire. That's just the way I am, and I've learned to go with it.
Also, when the other person wants more than friendship, the relationship usually fails. Initially, the person keeps hanging on in the hope that we will change our mind. Usually, we don't change our minds. We're either attracted or we are not.
No need to fret or feel bad, though. You just need someone who you feel a strong desire to be with physically, and with whom you will also feel loved and safe. We all need what we need. Some people don't want all that passion, but others like passion just fine, thank you very much. Having said all that, passion is like a tide, it rolls in and out, but when you really love someone, that flame burns steady.
Long story short, it doesn't sound like that "great person" you are talking about is quite right for you right now. He may never be, because physical attraction is important to you and that is all well and good. Best of luck to you!