Is there a rubber 'O ring' in the socket of the pipe coming up from below? Your description makes me think there isn't, hence why the pipe is loose. Tape will be adequate to seal it all up, the only moisture you may find in there would be steam from a hot bath or similar being discharged in colder weather, or any possible rain ingress.
That far bend still looks like you could have done it with an adjustable bend!
That far bend still looks like you could have done it with an adjustable bend!