Transformation of the Hamiltonian in excitation energy calculations: Comparison between Fock‐space multireference coupled‐cluster and equation‐of‐motion coupled‐cluster methods