The singer's brother John Burgess, sister-in-law Julia, and two of their children were tragically swept away by the flash floods in Kerrville, a town roughly 270 miles from their home in Fort Worth