The Artemis II mission was a glorious moment for space exploration and a sign of a potential $1 trillion investment boom in the global space industry over the next decade.