Sweating pipe is fun to learn if it's not an emergency. You'll probably get it wrong a few times though.
The bigger issue here is that the cavity isn't sealed so this is probably the tip of the iceberg in terms of the water damage you're going to find. Modern waterproofing systems have a rubber gasket which seals around the rough opening to divert water, but this goes under the tile.