If you think the 16” is “big and heavy” then it’s not for you, and you probably don’t need it...and you sure must be new to computers, because even a few years ago the “super thin and light” Retina models were reasonably bigger and a lot heavier.
The 14 will almost certainly grow in size & weight by tiny amounts vs. the current 13.3...it’s a “pro” laptop. And it will still be crazy thin & light for its given performance. If that’s still too much, then I would strongly suggest you look at an Air, because if you really need the power, a machine that’s slightly heavier & bigger than one of the smallest & lightest laptops money can buy wouldn’t be a deterrent. Something to think about.