Actually Cancer and Aquarius have things in common. Both are nonconformists and do things their own way. He's a little harder to pin down emotionally. But he is a romantic, even if he acts like it one day and ignores you the next. That's typical, Aquarian, erratic behavior. If he says he cares, with Venus in Cancer, he does, he's just changeable.
Since you also have Venus in Cancer, this is complicated. This position seems to make people sulky, and their feelings get hurt very easily. I had an ex-friend with Venus in Cancer. She was always going on about how everyone hurt her feelings or did something to her, but was very insensitive to others. You would think to be so super sensitive herself, she would be mindful of being kind to others, but she wasn't.
Since your Moon is also in Cancer, your feelings are strong, but also very changeable. This is OK with his Aquarian Moon and keeps things interesting.
I think you both are caught in a spiral of expecting too much from each other, but not giving the other the attention they deserve, kind of like my ex-friend. You can work on this, because all your other planets are in a zodiac sign too and that can be helpful in working this out. But if you each expect the other to do all the pampering and pout about it, I don't know if you can get past this. Talk about it and give it another try, but if it doesn't work, move on.