Museum sought to keep the site-specific work in place at 666 Fifth Avenue, but developer decided it had to go during renovation