I googled, impact prevents drill bits head from wearing out due to high temperature.
This is only partially correct.
All drill bits get hot. The energy you get from the power cable ultimately ends up as heat, only a tiny fraction is actually used to tear the bonds in the material. (Sir Benjamin Thompspn discovered the mechanical equivalent of heat exactly by boring.)
What the impact does is to make drilling much more efficient in stone/concrete. These materials are resistant to cutting, but are much less resistant to impacts, they are fragile.
Having a way more efficient drilling method you finish drilling faster and the drilling bit gets out of the hole, so it can start to cool down.
Drilling a deep hole in a hard material, you may still benefit from getting the drill bit out once in a while and cooling it by air or water. Or you can use 2 or 3 bits with a different length and change them as you progress deeper.
And yes, you CAN drill a hole in a stone/concrete/tiles by a rotary, non-impact drill. I did it few times when an impact drill was not available. Sometimes it is faster to leave the drill alone and hammer the drill bit against the wall by hand.
Masonry is way easier than concrete or stone for drilling with a rotary drill.