CyclingAbout has an amazing video on frame stiffness
https://www.youtube.com/watch?v=5f8PGpKUKro
i guess it makes sense when this article is talking about road bikes, but in MTB and gravel bikes, where geometry is so much more malleable, the geometry plays such a huge role in stiffness, almost independent of material.
you can have a crazy stiff steel bike (e.g. kona honzo esd) or a crazy compliant carbon bike.