>>1432876It still wears out, the tape becomes brittle and the glue melts. Better tape will last longer than cheap stuff, but it's not really a concern since most cycling enthusiasts replace their tape at least once a year.
Since it uses no adhesive, silicone tape might last longer. It would definitely protect your frame better than electrical tape.