While the singer is thought to have made a number of attempts to help her older brother, Andrew Tweedy, get clean, he was reportedly in court last month for being drunk and disorderly