A source told People that Stone's death had been 'devastating to him' and added the Brown Sugar singer 'never arrived at her funeral service. He was extremely overwhelmed'