Sophie Radford, originally known as Sophie Sue Radford, was seen being supported by fans after she shared a major family announcement