The difference is not caused by the focal length but by the distance of the subject from the camera. The only difference between a longer and shorter lens is the field of view. To get the same framing with a 24mm and 200mm you need to be at different distances, but that doesn’t mean the focal length causes the different look. If you took a photo with the 24mm from the same distance as the 200mm and you cropped it so the framing is the same, they would look identical.