I think you must assume that your SIL is a grown adult and can sort this out for himself.
We love our son in law, he’s a fabulous husband and father - I think your DD is in a better position to judge. especially on whether he is a good husband. You are not in a position to know what goes on in their relationship behind closed doors. Maybe he watches porn, or has personal habits she does not like ... maybe they have simply drifted apart - you are not in a position to make your statement above. And implied in that statement is a criticism of you DD and her decision - and to0 cap it mall you have offered him your spare room!
You are treading on thin ice here - you are saying that your judgement of him trumps your DD's opinions and decisions. I think that your DD would have every right to be pretty pissed off about that; and you are putting your future relationship with her in jeopardy.
How will she feel when she visits you, assuming she continues to do so?
Anyway - you have already asked him, so you will have to deal with the fallout. However amicable a split might seem, it is always very tricky at the start.