The first minister has urged Facebook's parent company Meta to remove the "unacceptable" video.