So recently I was learning about how the memory really works with it's memory addresses. I remembered that each bit is represented by a memory cell (transistor) right? So if we assume that the length for each memory address is 32 bit or 64 bit. Does this means that the memory could theoretically have 2³² and 2⁶⁴ of unique memory addresses (and memory) respectively?

Does this mean that if we want to calculate how much memory cells there are we should do: unique memory addresses * address length/size? That means that we will get 2³² * 32 memory cells for 32 bit memory and 2⁶⁴ * 64 memory cells for 64 bit memory? But this amount is enormous. This doesn't looks realistic right? It can't be that this is the amount of memory cells in a memory right? Can someone please explain to me how this works because I think I'm really confused about this.