Is this relationship doomed

Great up until 3years ago when we had our child. I lost sex drive, gained a lot of weight, suffered pd.

I was and still am left to do everything cooking shopping cleaning working part time and all child care. He works part time, attends his hobbies, plays computer games and can’t even take his dinner plate to the sink.

For a long time I begged he help more with child (to be told I hogged child) I’ll ask if he could go shop grab some bits (he would have an excuse ready) I would ask we spend quality time together and as a family (me and son go out often he stays home).

I’m basically a single mum to a toddler and grown man- this resulted in me never asking for sex or wanting it from him. Also I complain about nothing now and just get on with it while inside resenting this man more but still love him I think.

We have sex about once a fortnight. He started struggling to keep a hard penis. I took it as he no longer found me attractive or sexually arousing. Which to be honest with the issues we have I haven’t been overly bothered until today I found he has a prescription for viagra since 17th august (3have been used but we’ve only had sex twice).

I’m hurt unhappy and at a lost. Don’t help that I’m very low mentally at the moment