A West Cork community is mourning after a soldier who fought in Afghanistan was accidentally killed by a stray bullet during a training exercise in Wales.