Lifting weights will make you strong, not bulky. Your body composition will change; you’ll burn more fat to build more muscle; and you’ll feel more powerful in your own body.
To gain significant weight, you’ll need to not only lift very heavy multiple days a week, but you’ll need to eat well into the 3,000+ calorie range every day. It’s a very conscious effort to “get bulky,” so don’t fret!