The setting you are trying to use does not work in a footnote:
Edit & Manage Citations Dialog
Display as: Author (Year): Select this option to display both the author name and the year in the highlighted citation.
This feature does not apply when editing a citation in a footnote.
Since you are looking to get a custom format from the Turabian style I would suggest contacting Technical Support to see if what you are trying to achieve is possible.
1-800-336-4474 option 4 then 1
or
https://support.clarivate.com/Endnote/s/technicalsupport?language=en_US