How to avoid UART chip power consumption
I agree with all above comments, and will be moving soon to the bare chip in production. But before that, with NodeMCU ESP32 in hand, We have removed UART chip and 3.3 V Linear regulator.
Before doing this,

Added OTA code to the ESP32 just in case required updates in future.
Added external Non-Linear Voltage regulator buck after power supply and set the voltage to aprox 3.7V

Now the entire circuit can last more than 100 days with my specific use case where ESP32 walk-up daily for 100+ times, performs some operations for say 30 secs without Wifi and go to deep sleep. Also it connects to the Wifi once a day for 40 sec.
To answer my original question:

Yes, if we provide regulated 3.3 on NodeMCU pin, UART will still show the consumption.
Even 3.3 V Linear regulator on board also shows voltage on its output(Dont know why)

Meaning, if we are dealing with NodeMCU based ESP32, then these both the chips will keep consuming power even after supplying 3.3 V on pin.