I wonder if this will start a trend? They've already build Kranspoor in Rotterdam. Disused bridges present an ideal if unusual foundation for buildings, and they're usually in locations with great views.
As long as the bridge isn't terribly damaged or a hazard to navigation, the unused bridges can remain indefinitely.
Here's a similar proposal in Boston: