Memory returning, fool is in confused state (6)
I believe the answer is:
morass
'confused state' is the definition.
(morass can mean a muddled situation)
'memory returning fool' is the wordplay.
'memory' becomes 'ROM' (ROM is an example).
'returning' says the letters should be written in reverse.
'fool' becomes 'ass' (both can mean a stupid person).
'rom' written backwards gives 'mor'.
'mor'+'ass'='MORASS'
'is in' is the link.
(Other definitions for morass that I've seen before include "Confusion" , "Tract of swampy land" , "Bog or marsh" , "Tract of soft, wet ground" , "Muddled situation" .)