Autonomy Matters: A Study on Personalization-Privacy Dilemma in LLM Agents