Celestial amplitudes and conformal soft theorems