Charge density wave and superconductivity in the disordered Holstein model