I suspect you want to use renv::load() here rather than renv::activate(). The job of renv::activate() is to create a .Rprofile that then calls renv::load() automatically for you when new R sessions are launched. If you don't want that behavior, you can use renv::deactivate() and then just manually / explicitly call renv::load() as required.