I was in the Air Force in early 90s, and we chuckled at one guy in training who got assigned to B-52 maintenance. "Ha that old thing? How long will that job last?"
I read (a fairly long time ago) about a guy who joined the air force and ended up flying the same B-52 that his father had flown. One has to wonder if at this point his son isn't flying that same plane.
While on the other hand the need to stealthily deliver smaller payloads into protected airspace went away with the end of the cold war, for now. It might become again a necessity in the future.
On the delivery large bomb payloads into dominated airspace the B-52 is unbeatable so far.
I think a modified and militarized Boeing 777 (or 767) would be the ideal replacement for the B-52, though I realize a lot more goes into bomber design than just selecting a successful airframe.