Does a bench warrant become inactive, ie; no longer in the system

Depends on what the bench warrant is for. But generally, no, it does not expire.

Most arrest warrants never expire, I have known some city warrants to expire for bench warrants for traffic violations and code issues