Queen rockstar Sir Brian May has shared a touching family tribute online with fans flocking to the comments to share messages of support