Do I need to sign into Steam every time I use Aurora Vision?

No, you only need to sign into Steam the first time the system is set up or if your account is signed out of Steam.