Oh yeah big time. The best thing to do to get a feel for this is to load up a game that has vRAM estimates in the video memory (Doom Eternal, RE3, FarCry5, CoD:CW etc) and then change the individual visual settings up and down and check the difference in estimated vRAM usage. There's often a significant swing if you switch from everything max to everything min. This tells you something important, games do not have a fixed amount of vRAM usage, it varies a lot depending on the settings you use. We can speculate about future games and their higher vRAM usage but we have to be careful when we do that, a game in 4-5 years time we could put in all low/min settings and the vRAM usage would be smaller than games maxed out today. So what we really mean when we say future games will be higher is specifically in a like-for-like comparison, which might be something like the game maxed out in Ultra at 4k now, vs a game in 4 years also maxed out in Ultra 4k.
My testing yesterday in CoD Cold War putting everything on min got me down to 2.7GB of estimated vRAM usage, although you cannot disable/uninstall the high res texture pack from the game menu you need to do it via battlenet or something daft, so I didn't bother with that. And then I maxed out the settings and it's about estimated 9GB of vRAM usage. The menu estimates aren't always that accurate but they'll give you a pretty close feel for it. Texture data is typically something like 1/3rd when everything is maxed.
Anyway newer games will put more demand on the GPU as we can see from the very latest games today you can't run in everything maxed out, not even with a 3090 which means you need to sacrifice some visual settings to get it playable, and when you do you free up vRAM.