While it is a bit "sad", it's also "good" that those aircraft have been put to pasture. They served this country well, but metal fatigue is something that you don't want flying over you, or for flying in. At least they will be chopped for future usage....and I'm sure that several will be kept for viewing.
There's a restaurant, called the "Proud Bird", that is underneath the approach pattern of Los Angeles International Airport. They have numerous war birds on display in the back of the restaurant, and two are "flying" from elevated pedestals in the front parking lot. P-51, P-47, Mig-15, F4-U, X-1, X-15, and several others.....but not enough room for a B-52.