My guess is that since your delay was weather related you are out of luck. Some say that is why there is travel insurance. You could try a note to TTU and perhaps get some miles for the delay but if you are looking for compensation for your extra night in DTW I do not think you will be successful.
Unfortunately the hard facts of traveling in 2008.