No. You do not need to provide him with your social security number, unless he is claiming you as a dependent. Make sure your former spouse is filing as Head of Household when it is his year to claim the children.
In this case it is possible that TurboTax may be asking your former spouse for your social security because he is still filing as "Married Filing Jointly"