It depends on the people in question and how open minded they are. If either one wants good sexual compatibility but the partner isn’t able to provide it, that’s a recipe for disaster. If you both don’t have much of a sex drive then it’s probably fine.