Usually, yes, if you turn off beta access, once Apple release Tahoe to the general public, it will simply appear when you check for updates, and then once updated you'll be on the official release version.
However, I would recommend waiting until the conclusion of the Apple event today. Usually not too long after that — generally within an hour or two, but it can be longer, so certainly by Wednesday — Apple will release the final release version of Tahoe, through the beta channel. Absent any major last minute bugs or issues, this will be completely identical to the final public release.
It's released early to give developers a final window to test against, so as mentioned, unless there are any showstopping bugs, what you will be able to get access to will be exactly the same version the general public will get. The same goes for the iOS, iPadOS, tvOS and watchOS updates. New iPhones will for example be running whatever build of 26.0 fresh out of the box, as would new Macs (if any are released, which seems fairly unlikely, but you never know), so any tweaks Apple make would generally follow in a .0.1 update or similar.
It's been this way for quite a few years so the cycle is unlikely to change today. It's a good way to beat the activation server rush and things that can get busy when the general public is piling on, but Apple's servers are pretty solid these days. Still, nice to be ahead of the curve
