Weeks before his final red carpet appearance, a Los Angeles Superior Court judge ruled that Brian had to have a conservatorship set up to care for his personal and medical needs; seen with his late wife Melinda, who died in January at 77, in 2013