The English musician shared a vulnerable post about his recent struggles as an artist and was greeted with a wave of support