I told them at 12 weeks so we could talk about it in front of them, but we didn’t really prepare until around 28 weeks or so, when we started explaining what would happen and what would be different/same.
I love Joanna Cole’s book - it actually focuses on having an infant in the house, while so much else is about sharing, etc that doesn’t come up for a long long time.