Norfolk council leaders have been urged to stop "clutching at straws" and accept the £274m Norwich Western Link will never be built.