The space race was a political decision taken by JFK in 1962 as for popularity - it didn’t seem unpopular at the time. Certainly the Vietnam War was less popular, and a great deal more expensive in lives and dollars, that ended in failure, at least the moon landings were a success.
The sacrifices in family life is taken by every member of the armed forces, they can be sent away for many months, families have no idea what risks they are facing, or wether they are going to be killed or maimed. I would suggest that Neil Armstrong faced a lower level of risk than the Marines in Vietnam, certainly less than our own men in the trenches in WW1. The film was dramatized, wether it is an accurate record I have no idea, personally I would not have wanted my wife to listen to the commentary live of the space flight, it was guaranteed to upset her.
With hindsight was it all worthwhile?, human endeavor has no bounds, we had to prove that it could be done just like climbing Everest, running faster or jumping higher.
Has mankind benefited, 50 yrs on I don’t think our lives would be much different, the scientists would say our understanding of the universe is important. Maybe in another 50 yrs interplanetary travel will be possible, even essential, only time will tell.