Tiles have technically no transparency. Transparency is only for sprites. NES has also only one tile layer so tiles can't overlap one another. If you want transparency, you need to make a monster of a tree, but then you run into other issues (sprite limit, monsters not being solid and so on).