Depends if you assume people are rational.
A rational economic actor would not be a NIMBY under these conditions, because the increase in land values exceeds the increased tax they would pay, and so they could always sell their property for a profit and buy another one farther away from infrastructure if they don't like it.
In reality, people are change-averse and irrational for a variety of reasons, chief among them emotional attachment. So it wouldn't surprise me if people resist development in practice. A lot of NIMBYism is already of this vein - upzoning a property usually increases its value (because it can be redeveloped into more units), but is also frequently fiercely resisted by existing residents who won't sell at any price.
Note that a system can be rational even if participants are not - capitalism is, because actors who are irrational eventually go bankrupt and are forced to work for actors who are economically rational. That doesn't stop it from being unpopular, which, again, capitalism is. Many of the political issues getting an LVT adopted stem from this.