23.976/24 is a ‘look’ as in film look. 29.97 progressive does some similar things but features much less judder.
Depending on how you move the camera, lighting, framing, anamorphic, fps all contribute to the ‘look’. if you reduce only one feature, if the others are professional, most people won’t notice.
the lower the framerate, the heavier use you need for warp stabilizer or steadicams etc. plus 7 sec panning speed. :0