Can you really have it all ?

I ask my fellow glow members to hopefully give me some good advice . I dated the same person for 2 years at first he was not my type but he was so persistent I gave it a chance and it was one of my better choices sexually we had a good relationship and emotionally also but I always thought about my ex and ended up breaking up with him to try things with my ex again which didn't work out we got back together and 5 months later he passed away from an enlarged heart . Now years later I'm in a relationship and have been for 1.5 years and I love him so much we have a good time together and  I love his family this is my first real adult relationship and we live together but our sex life has always been less than ideal for me . We have sex once a week if that and he doesn't eat me out ever like he used to but I honestly can't ever imagine not being with him . So my question is can you have it all? Or will there probably always be something that's less desireable in a relationship? Or am I selling myself short