Asus Vivobook 14 Flip (TP3407S) Screen Cannot Auto Rotate (Sensors not functioning)

Sensor support from Intel has not been supplied to the Linux Kernel, by 6.17 :

Before suggesting trying the 6.19 kernel, I took a look and did not find any references of inclusion of Lunar Lake Accel or Intel ish_ipc

It is worth trying the 6.19 or 6.20 kernel, just to be certain but... It looks, from everything I have read so far that module support has not landed, yet.

NOTE: You likely will need to disable Secure Boot, as the latest kernel will be not signed off by Microsoft. Nor would the drivers/modules be.
(If Secure Boot is critical for you for some reason, you would need to enroll MOK and sign off on the packages yourself.)