On Thursday night, the Roundabout Theatre Company’s highly anticipated revival of “The Rocky Horror Show” opened at New York’s storied Studio 54—with Tony-winning Oh, Mary! director Sam Pinkleton at the helm and an all-star cast.