“We exhausted ourselves trying to help Scott and be a friend. He wanted no part of that.” The story behind Stone Temple Pilots’ ill-fated sixth album, as told by the band themselves