Extragalactic radio source stability and VLBI celestial reference frame: insights from the Allan standard deviation