Hi, and thank you for your question!
The TimeCore's functionality in 29.97fps is limited to drop frame only, I'm afraid. So, like you discovered, using 29.97 NDF as input will give you the significant drift.
To work around this, perhaps you can switch things around and have the TimeCore be the timecode source?
We can discuss in detail how that could work in your setup, if needed / wanted.
Kindest regards,