The song has been lauded by many in the pro-Israel and Jewish community. But its tacky, occasionally offensive execution may earn more detractors than supporters