Millions tuned in for Artemis unmanned mission but left disappointed after a fuel leak twice caused postponement; next potential launch window between September 19 and October 4