"Golden shower" is a slang term for urolagnia, a sexual fetish. The name in Terraria is likely referring to the fact that the attack resembles a stream of urine.