For years the CBS Arena was a monument to Coventry’s miserable plight, writes Lawrence Ostlere. Now it is their true home as they near a remarkable return to the top flight after 25 years away