The once glorious club is in disarray and middling in the second-tier tables, with its last Champions League semifinal years behind