I was another person who suffered from motion sickness trying to play the original Super Mario 64.

I wish I could tell you what it was - I have played everything under the sun, including VR (in which I was also motion sick), and the closest thing I could come up with is the low FOV combined with the automatic movement of the camera.

I think it’s similar for people who get car sick as a passenger, but not a driver.