It could very well fly again.
The Goose recently restored in Ketchikan was goundlooped and the center section was quite warped, but it is or will soon be airworthy (though N-88821 will never fly again).
The real question is who needs and can afford it's unique capabilities.
(The nose is a baggage compartment and a photographer can take some interesting inflight photos riding there)
Or maybe the Ketchikan project has a new parts donor.