Steve, it worked for us but only because we used the house as a base for travelling.
We only had short stays not full time living.
For us, based on experience, for full time living we need our own place away from family.
I'll not detail all the reasons, but living with family can be too much of a drain (emotionally and financially)

Please think very carefully about doing that in the future.