Yes. As far is the public is concerned police are never off-duty when they want to charge you.
Off duty only matters where their pay is concerned, or in being able to refuse to help you when you want help.
The fact that you have no recollection makes me think the copper did the right thing.