My experience with this, and it is rather extensive, is to just buy a new tent if you're concerned about the waterproofing. You can spray waterproofing shit on there til the cows come home but it'll never fix it long term. Buy a tent with an actual waterproofed cover and you won't regret it. My experience with nikwax, which again is rather extensive, is that it's basically good as a water repellant for a few rain events. My current tent, a hilleberg jannu, admittantly a very expensive 800 dollar tent has a tub that you could set in water and it wouldn't leak through. There are other tents for much cheaper that do the same. REI makes some good basic tents that are waterproof. If you camp more than once a year then spring for a good tent. Life is too short to sleep in a shitty tent.