I thought your topic was very interesting, but I could find nothing on the reasons for their demise. That left me to assume that the reasons for their need were resolved with modern diesels.
This website, MountainWestRail, with detail on the Burlington Northern, hints at various issues, including frame stress, but, seems to indicate in 2002 that they (diesel fuel tenders) were returned to service for certain uses.
Canadian Northern, BNSF and UP are testing duel fuel engines with LNG cars. You can find examples of these and some of the manufacturer's information while searching. Technology advances to allow the equipment that returns the LNG to CNG has improved and is now on the fuel tender and advances in the engine design are making this attractive along with significant fuel cost savings, of course.
A closer look at LNG
Fuel Storage-LNG locomotive tender car
The common link for these, as most railroad equipment, is cost. The fuel tenders also address the convenience of nearby supply(or lack thereof).
Did you have a link to an article that discussed the forces imparted to rail cars?