Not really, a sunset clause on the debt ceiling would mean after sunset there would be no ceiling, as it is a completely artificial invention anyway. Most countries don't have a debt ceiling.
It’s similar to the proposal in that not passing a replacement bill (“raise the debt ceiling” : “murder is illegal”) would have very obviously negative results.
The debt ceiling is a functional sunset clause on the ability of the US government to pay its bills.