Yeah, even if you were someone with an Extra Attack, it's not worth losing your normal attack to do a mere 2d6 acid dmg, let alone for a Rogue (if you want a 20ft attack, just throw a dagger).
Holy Water does get doubled to 4d8 if it's against someone with radiant vulnerability, which is an...