Open limping w speculative hands in MP (and I'm being generous calling this a speculative hand) is a leak - how many flops are we looking to hit w this hand? If raised pf, as you say, we fold and lose a bb.
Against better opposition, getting all in on the flop w bottom set, even in a cap game imo, isn't a great idea imo. If someone's willing to get all in, we're probably flipping at best (here, we're 53%, change his hand a little bit and it's not hard to make it 47% - you can run simulations at www.propokertools.com
- try changing the 8d or the 9d to the Qh) and at worst dominated by a larger set.