Brian's children announced his death on his official Instagram page this Wednesday, alongside what appeared to be a recent photo (pictured in 2020)