I had one submission sit in the approval queue of an inactive stream for about a year and a half.
Sitewide Moderators can help get inactive streams going again by claiming them, then inviting new Stream Moderators and promoting them to Stream Owner if they think it would be good for the stream.