I love the Opry and have a huge collection of books, programs etc. related to the show, but I'm not sure of the future.
The average age of most of the performers is probably 70. The newer members just don't play it often enough. They also kind of missed out on making most of the stars of the 70s and 80s members so you don't have as many performers who are in their 50s and early 60s who are passed their hit making stage who should be a natural for regularly playing the Opry.
The last few times I've been, attendance has been mediocre. They often just have one show on Friday and one show on Saturday. When I was a kid, they always had two shows on Saturday and most of the year two on Friday and all were usually sold out.
I'm not saying the show is going away, but it could be in a very different form 10 years from now. Obviously closing Opryland didn't help, so maybe Dolly's water park will spur attendance. But the age of the Opry regulars should also be a big concern.