The description is not a metaphor. “Lost my marbles” is a common one for psychosis, dementia and the like, though.