Text this: Excessive precision compromises accuracy even with unlimited resources due to the trade-off in quantum metrology