The Charleston RiverDogs -- the NY Yankees' minor league affiliate -- has canceled their "OJ Trial" night promotion ... after admitting it was a TERRIBLE idea in the first place!!! Here's why ... the South Carolina based team promoted the May 26…