"Could some of Detroit’s abandoned schools be preserved and transformed in a similar manner?"

Of course they could. It already has happened in cities throughout the United States. Does the leadership who can make this happen have any sense of vision? None whatsoever, so you will see nothing become of these buildings.