RAM determines how much your computer can handle being open and actively running at once. CPU is what actually crunches tasks and does stuff. These are not the same things. Therefore, one will not offset the other.
With 8GB of RAM, you will notice slowdowns as you open more things and attempt to do more at once. I would not get 8GB of RAM on a new Apple Silicon Mac in 2024. You may not feel it, but your computer will be using up most of, if not all of that 8GB of RAM just handling the basics (and it's always advisable to have some overhead in case a process or program ends up demanding more RAM).
Unified Memory doesn't negate the fact that 8GB of RAM is still 8GB of RAM. Nor that 16GB of RAM is still 16GB of RAM.
All "Unified Memory" means is that the same RAM that your CPU is using is also the same RAM that your GPU, NPU, and every other part of the SoC is using and that the data in that RAM can be read by all of those parts without having to go anywhere. It means your RAM is more efficient. It does NOT mean that your RAM is more voluminous or capacious.