The search for a missing fisherman in Queensland has come to a tragic end after a body was discovered.