Yes the end is at hand!!! But....repent of your frequent flyer sins and gift all of your miles to
84fiero and you will be saved!!!
While it's fun to conjecture, I don't think any of us here can answer that question with 100% certainty (unless someone works for a bank's CC marketing department perhaps!)
Maybe there will be an avalanche of new big offers, maybe nothing more will pop up. I don't worry about it. Heck, none of us really knows for sure what tomorrow itself will bring for life in general. Just be flexible and a bit creative, to maximize the benefit from whatever does come about.
Perhaps in 10 or 20 years it won't be CC bonuses but something else entirely that we focus on to feed our wanderlust.