Fractonic Berezinskii-Kosterlitz-Thouless transition from a renormalization group perspective