I agree about the selection - books that strike a balance between accessibility and depth really are scarce. But there are still a few worth your attention. The main thing is to start with something like "Life 3.0" by Max Tegmark - he doesn't rely on math there and focuses more on the philosophy of AI development, where it might take us. It reads like a compelling narrative, not a textbook.
If you want something more specific about how neural networks actually work but without programming, I'd recommend books on AI history and practical examples - they cover stuff like GPT and computer vision, but you won't get bogged down in formulas. Those books are usually built around specific stories and case studies, which is way more interesting than dry theory.
And honestly, don't get fixated on just books - there's a ton of great YouTube videos and podcasts now where experts explain the basics without technical jargon. Sometimes a 20-minute video gives you more understanding than two chapters of text.