Police have found the body of a man who disappeared into the waters of the Brisbane River while “extremely drunk” in front of family and friends on Saturday evening.