It needs to become part of life not a separate thing. It's your weekends that's the problem. If you prioritize the chores then you can relax in a clean and tidy home or do fun stuff guilt free. Family visiting/days out every weekend is unrealistic, as is football both days unless your DS is capable of taking himself off to the park to do it without supervision. Basically everyone else in your household is getting to do their version of fun stuff and it's only you who is missing out. You run round after them all week doing chores then weekends facilitating their fun. You're not a servant you're part of this family. They need to pull their weight with chores and start considering what you need on weekends, which might be a day at home Sunday resting sometimes.
Firstly your DP job doesn't mean he gets to do less housework or childcare, you're tired too. Both of you need to tackle the house eg Saturday morning for a few hours, clean it top to bottom. Not a spring-clean moving-furniture and cleaning windows type thing, for that you both need a day annual leave. Just a regular clean: bathroom, kitchen, vaccum carpets, mop floors, change bedding and towels, dusting, stair rails and door knobs. Should take a couple hours with two doing it. Also the ironing and food shop for the week, another few hours maybe.
The rest of the week don't touch it unless proper filthy. You can clean/tidy a bit while waiting for the kettle to boil.
Everyone needs to get into the habit of putting things where they belong, as soon as they've finished with it, no dumping it wherever and leaving it for you until later. So homework with school books not spread all over, coats on hooks by door, shoes by door, washing in the laundry basket, toys in toy box, hobby stuff packed away, half read book and magazines on the coffee table etc. If you do this consistently there'll be almost no tidying needed before the weekend clean starts.
Everyone needs to rinse the bath down quickly after they've used it so the scum ring doesn't need dealing with until the weekend clean. Everyone needs to scoop their crumbs into the bin before eating the food they've just made or it won't get done and bring their dishes to the kitchen straight after eating, with any rubbish going straight into the bin, nothing left stacked on the side covered in food and wrapping for you to deal with.
In future try to purchase clothes which don't need ironing. Don't iron bed sheets etc.
Find the hour or half hour cycle on your washing machine. Put a wash load on in the morning every time there is one and hang to dry all day while you're out, put away on your return. Anything needing a longer or hotter wash can be done at the weekend.