Bill O'Brien has been sacked by the Houston Texans, saying he is sorry he couldn't bring a Super Bowl to the franchise.