A frantic police hunt to find a man resulted in a “sad outcome” after his body was found in Waterlooville woodland.