Are successful relationships with disabilities possible? Yes! It may take time to find the right person for you, but that is the case for any relationship. People with disabilities are just as capable of having loving, long term relationships as able-bodied individuals.
Just because you cannot work due to your disability does not mean you are worthless. Everyone has a different path, and everyone has a purpose.