I understand completely.
I have a 7yo, a vey demanding full time job and a husband who also works full time and doesn't drive so can't help with any of the ferrying.
I have found that the only way I can cope with school holidays is to accept it's going to cost a fortune (£45 a day) and book a good solid holiday club. It means we have to save up throughout the year and sacrifice other things to cover the cost but it's been so worth it.
Trying to juggle family, friends, shared care always goes wrong somewhere or comes with so many obstacles it just adds stress and frustration.
This summer, I took week 1 off to spend with DD then 4 days a week she has gone to the outdoor pursuits centre 15 minutes drive away where she's spent every day kayaking, abseiling, climbing, doing bush crafts, archery, fencing..... she gets home happy, full of stories and absolutely shattered each day and is ready for sleep by 7.30pm.
Friday she spends at home while DH and I WFH, we have activities set up for her to do, make sure we hang out at break and lunch times which we stagger so she has less time entertaining herself and we are available for chat in between and she just rests up and takes it easy.
I then have the final week of the holidays off and we have activities booked and will go and get the new school shoes, haircuts and other last minute things sorted.
If there is any way at all to cover the costs I really cannot advocate enough for signing up to a good holiday club, even if it's just a few days a week.