OP I hope you come back to this thread as I've come to it late, read everything you've posted and most of the responses, and have some book recommendations for you. I'm in a different situation to you but still pretty tough, burned out for other reasons. I was an avid reader for decades including as part of my degree but as I've got older I've stopped being 'able' to read - I listen to podcasts and the odd audiobook whilst walking/ running (for sanity) or cleaning/tidying, but I genuinely and very sadly can't manage proper reading these days.
However what we DO do, is read to DD for 20-30 minutes every evening - she has dyslexia and various other challenges so bedtime reading isn't for her even though she's 10, however we do read to her, alternating between me and husband (but all 3 of us there almost every night, so one of us reading and the other listening/ trying to stay awake!)
Our favourite books recently, which we entirely stumbled across, are Robin Stevens. I'd recommend them to any adult who is an avid reader but they are children's books so no sex scenes which is why I'm recommending them to you, OP. There are 2 series, and we stumbled upon the second first of all - The Ministry of Unladylike Activity - set in WW2 with 3 pre-teens as the protagonists. They are diverse and richly detailed portraits of life in WW2 from various perspectives I personally hadn't previously considered before. They are basically Agatha Christie for kids (with a bit of Mallory Towers/ Enid Blyton chucked in - but written from 2020 onwards so very modern in many ways whilst also being very historically accurate). They've been a genuine delight. I recommend starting properly with the first book in the first series (rather than as we did, starting with the second series) - Murder Most Unladylike.
As an added bonus for you, more than one of the characters is seen to be neurodivergent and I gather the author has recently-ish been diagnosed herself.
Also I'm here to tell you that whilst I'd prefer to have the time/ energy to gobble these up in a single sitting as I always used to joyously read, since we are reading them to my DD I can tell you they work absolutely fine in 2-4 chapter chunks!! though they always leave me wanting more.
Recommend, to you and others. And perhaps your kids might like too...?