How can I create a rounded top for this elbow?

Based on your screen shot it would appear your pipe isn’t round in cross section. Holes would likely be due to working at too small of a size. Try scaling up the model by a factor of 100 or 1000 before running Follow Me. Or use the Dave Method.

Can you upload the SKP file?