Detroit , whose population of 900,000 is half as large as it was 50 years ago , spent years improving the look of its downtown before crowds arrived in July 2005 for the All-Star Game at Comerica Park and in February for Super Bowl XL on the Detroit Lions ' adjacent home field .