I did the repair today and it seems this wasn't worst than that double sided tape that came off in this area.
I see that the other side is starting to fail too, I wait for it to come off so it will be easier to remove it.
if you wish to replace it before it totally fails, cut it using fishing wire.
For the repair I used the 3M VHB 4910, it needs a 10mm wide ribbon.
I first pushed back in place the parts and stuck a piece of masking tape along the edge to be able to align them when gluing them.
The old double sided tape comes off quite easily, with the little finger we can rub it off without pulling too hard on the parts.
I cleaned with alcohol the contact surfaces and put the 3M tape.
This is the hardest part as there is not a lot of space to slide it in place while keeping the ability to peel the protective layer of the tape after as it sticks well to it too. The best thing to do is to peel the red protective layer a little bit before sticking it.
Align well the part before pressing it as this tape is really hard to remove once glued.
(the reason of the piece of masking tape)
Once glued, if there is some double sided tape bulging on the side, just cut it with the nail to avoid making scratches with a tool.
In the datasheet 3M indicates that the bond build rate is at room temperature 50% after 20min and almost 100% after 1h and reaching it's maximum after 72h so it is better to wait 1h before driving the car to make sure the tape bonded well.
Also when getting this tape, make sure you buy some genuine one that comes in a cardboard box with a chain printed on it as even items sold by Amazon seems to have some exotic origins that are not the 3M Store or VHB Store.