TX RX Defaults in ESP32 C3 Xiao with SDA SCL

Is the xgxp6897D power supply pin connected to 5V? If so, try connecting it to 3.3V.
Use “I2C Scanner” to see if the address of the xgxp6897D is detected.
What is the link to the actual sensor you are using? Is it a stand-alone module? Or is it a breakout board?