Advances and Challenges of <scp>SCAN</scp> and <scp>r<sup>2</sup>SCAN</scp> Density Functionals in Transition‐Metal Compounds