“That was a childhood dream come fucking true,” the musician acknowledged during the show