Long distance relationships are difficult and you have to ask yourself if the distance is part of your unhappiness. In a long distance relationship the intimacy is never going to be there as in a regular relationship. The question is whether the issues making you feel this disconnect can be corrected. For instance if he has a lack of ability to connect with you that may not be fixable. But if he needs help expressing himself that is fixable. Only you know if you can live with his personality and what you can't live with can be changed (assuming that he wants to change it). This is more than having something in common. You have to want this relationship as does he. Before you approach him you have to decide what you want. That has to be decided first. Decide if the disconnect is something that can be addressed by you as a couple.
As far as sexual pleasure that has to be part of your decision. If sex isn't going to be enjoyable than that plays a role in your decision. He also has to be willing to compromise. It's not about his sexual pleasure all the time.
This relationship has serious issues. If someone lacks passion that is going to impact the relationship indefinately. This child will also be a stressor. Even though you have talked about it this still will play a role as the child grows because the child may want to have a bond with him.
If you have a hard time breaking up with people then this could be that problem occurring in this situation. You don't want to hurt his feelings so you are doubting yourself. If the relationship isn't working or there is something you can't live with then end it nicely but with a period. Be honest with yourself in evaluating everything and decide if you want this guy without basing it on his reaction.
If this has been helpful press accept