As others have written, it's more about the engineering. If you engineer an aluminum bike to be compliant, it will quickly reach its fatigue limit and fail. So aluminum bikes are deliberately made to not flex. Steel can be allowed flex a little. Too much and it's whippy, too little and it feels like aluminum - or worse! Likewise carbon and titanium are built to the desired stiffness.