Background Pony #6069
I remember someone telling me that Celestia did not accept that role, because she feels partly responsible for her sister’s corruption, and she would not want someone very close to her to suffer something similar…
But basically, Cadance was added as a surprise in the series, obviously it was not planned and therefore it would not make much sense for her to be Celestia’s daughter. Also, I bet many would have wondered, who would be the father? and things like that, it would have been chaos.