Girls Aloud singer Cheryl Tweedy previously opened up about how the death of her former bandmate Sarah Harding completely changed her outlook on life