> Isn’t that a demonstration of the fact that the moon mission was an engineering dead end?

Dead end, yes; engineering, no. More: we didn't need it for so long that everyone who was responsible has since gotten old/died.

And even then, only a dead end given the scientific and industrial position at the time; those can change to turn dead ends into open ends.