* https://www.goodreads.com/book/show/677285.Ignition_
It's not about rockets in general, but about rocket fuel specifically. It's the "#1 Best Seller in Petroleum (Engineering)" category:
* https://www.amazon.com/Ignition-Informal-History-Liquid-Prop...
[0] https://www.amazon.com/Ignition-Informal-Propellants-Univers...
From someone who helped develop the lunar lander, there's Thomas J. Kelly's "Moon Lander: How We Developed the Apollo Lunar Module": https://www.amazon.com/dp/1588342735/
Another good book (so I've heard - I own a copy but haven't made time to read it yet) is Sunburst and Luminary by Don Eyles, who worked on the guidance system at MIT: https://www.sunburstandluminary.com/SLhome.html
For deep technical details (but light on first-person stories), there's How Apollo Flew to the Moon: https://www.goodreads.com/book/show/2323178.How_Apollo_Flew_...
Finally, not strictly related to the space race, but for some truly wonderful first-hand tales from the development of rocket propellants, you can't beat John D. Clark's Ignition!: https://www.amazon.com/Ignition-Informal-Propellants-Univers...
This is all assuming yields and fuels we have now. If we lived on a more massive earth and we were trying to escape its gravity, I'm sure we'd be using more exotic and dangerous fuels (like all those fun fluorine and boron fuels Dr. Clark mentions in Ignition![0]) to do the job. We just happened to have the capability in the middle of the century to use a fuel we were already making (refined petroleum) for jet engines.
[0] https://www.amazon.com/Ignition-Informal-Propellants-Univers...
https://www.amazon.com/dp/B076838QS2
Well worth the money. I don't think I'd pay the $90+ people are asking for a hardcover version...
https://www.amazon.com/Ignition-Informal-Propellants-Univers...
Boranes are unpleasant beasts. Diborane and pentaborane ignite spontaneously in the atmosphere, and the fires are remarkably difficult to extinguish. They react with water to form, eventually, hydrogen and boric acid, and the reaction is sometimes violent. Also, they not only are possessed of a peculiarly repulsive odor; they are extremely poisonous by just about any route. This collection of properties does not simplify the problem of handling them. They are also very expensive since their synthesis is neither easy nor simple. But they possess one property which attracted rocket people to them as hippies to a happening. They have an extremely high heat of combustion — gram for gram about 50 percent more than jet fuel.
[0] https://www.amazon.ca/Ignition-Informal-History-Liquid-Prope...