Aaron Carter's Manager Recalls His Final Days, Says He Looked 'Thin,' 'Extremely Tired'