So I've found there's two different 'pleasure' experiences:

One is during the workout where you disassociate and just feel your muscles working. In running this is usually called a "runner's high", and in weightlifting it's typically refered to "lifting heavy thing make me happy" / "Big rock make sad voices go away"

Then there's the after-workout where you just feel your muscle exhausted as you relax and it's extremely satisfying. You know you're getting stronger and the workout will be easier next time.

Both of these feelings take a few weeks to start, you'll have to get results from your workout and then your mind and body will start rewarding you with dopamine for doing a good job. (Although some days working out still sucks ass though and is both tiring and a chore, that part doesn't go away it's just easier to ignore).