Disney's much heralded $1 billion investment in OpenAI is over as the Sam Altman-led tech giant shuttered its stand-alone Sora text-to-video app.