Would this lip piercing look alright?

Sure. I have the exact thing. I sometimes wear retainers in mine, sometimes tiny jewel studs, and other times just regular labret studs.