A house in a sleepy village in south Wales has been demolished after being ripped apart by Storm Bert.