Music executive co-founded Sire Records, inked deals with The Ramones, Talking Heads and The Pretenders, said he felt pressured to stay in closet due to Judaism