If you're looking for a reasonably technical (but not completely rocket science!) history of the British space programme A Vertical Empire by C. N. Hill is really good, although, as a Brit, also quite depressing as you realise what might have been
https://www.amazon.co.uk/Vertical-Empire-History-Programme-1...