This likely won't work well long term.
Roots need a lot of oxygen, and as the author already stated, the water can get stale quickly. In my opinion, changing the nutrient solution "every few weeks" is nearly not enough. For pothos and the others mentioned this might work for some time, but even there, aeration is needed.
Another problem is algae growth. I tried using transparent glass bottles a while ago, and after just a few days, the whole bottle and roots were coated in green sludge, killing the plant.
There are a few great solutions for those problems. You absolutely can (and maybe even should) use hydroponic systems indoors.
My two favourite ones for that are Kratky and expended clay bubbles. Both are really great!