Photon‐shot‐noise‐limited transient absorption soft X‐ray spectroscopy at the European XFEL. (20th February 2023)