An uncrewed American lander that became the first private spaceship on the moon has met its ultimate end after failing to "wake up," the company that built it said.