I'm having trouble with the être flanquer
Se flanquer dedans means to land oneself in it.
Se flanquer en l'air means to top oneself.
So my translation is someone who will smash up their gaff after giving themselves (or being given) a good kick up the ar5e.
Maybe its someone that only gets their finger out after having a fire lit under them?