As I said, this is not the point at all. how much your middle name comes up in conversation is totally Irrelevant. Clearly you still know what your own middle name is. If you feel stupid about it, you feel stupid about it, regardless of what other people think or say or even know. Like, if you think your dress is ugly it doesn't matter how many compliments you get on it. If you hate your new haircut, it doesn't matter how much the stylist loves it! But you can change your dress in a matter of a couple of minutes, and your hair will grow out or it can be re-cut or re-styled in the interim.

Names can be changed, but it's not always such an easy process because they're so much a part of your identity. There's never any guaranteeing how your child will feel about their name, but OP asked for feedback and especially about anything obvious. Luna June, obviously, rhymes and to many ears will sound very silly indeed.

Oh, and btw my middle name comes up all the time. I'm in a location and a personal situation where I need to use both my first and middle names routinely. Not necessarily in conversation, but on official and legal forms. So it's always in the forefront of my mind.