How to acknowledge a retired professor?
I usually see acknowledgements in papers with just the full name of the person, regardless of their degrees or academic status.  No "Prof." or other honorific would be used at all.  "We would like to thank Jane Doe for helpful advice regarding our data analysis."