Should I stop drinking water at night completely
No. Staying hydrated is important. The goal is to reduce excessive intake close to bedtime, not eliminate fluids entirely.
Can poor sleep really cause the urge to pee
Yes. When your sleep is disrupted, your brain becomes more aware of body signals, including the urge to urinate, even if your bladder is not full.