A light-polluting green hydrogen plant project that would seriously affect one of the world's most important astronomical observatories has been scrapped by the company behind it.