Yes, a wall flange with a polished brass finish can be used to mount a shower curtain rod into tile, provided it’s designed for fixed rod installation and you use the correct hardware for tile.