In Italy, it would be a bit of an old lady's name. I also find it too short and personally I'm not sure I'd want to name my daughter "pious", it's a bit odd if you're not religious at all.
I'm not particularly bugged by the "pee" sound, possibly because I'm used to the name.