I have the Mark 3.0 (or 3.1, not sure) version of the same frunk kit (currently removed due to multiple cinch motor failures). I'm pretty sure this is what has happened to you too - i.e. the cinch motor has failed shut and won't disengage. I would be surprised if the OEM latch mechanism has failed, to be honest, and it sounds like the latch is actuating in the video.
There is an emergency cord that is supplied with the kit, usually tucked behind the towing eye, I assume you've tried pulling this? If the car is unlocked it should allow the latch to be opened, the 12v doesn't have to be dead (the conditions are the car is either unlocked OR the 12v is dead). From what I've been led to believe you have to pull
really hard on this, possibly even using pliers for more leverage. I've heard of people snapping the cable in the process of unlatching it too.
If that all fails realistically you have limited options, I think. I have heard that you can partially disassemble the wheel arch trim to get access to the cinch motor to do something with it to release it, but I don't know the specifics on that I'm afraid.
If that doesn't work you will basically have to get Tesla to gain access to it, which will involve partially disassembling the car from underneath. Expect it to cost a couple of hundred if not more in labour, sadly.
I was in two minds about refitting my EVOffer frunk kit, I removed mine because I wasn't driving the car enough and being directly attached to the 12v battery the parasitic drain and constant slow discharge & recharge cycles was killing it. I'm on my 3rd one (under warranty, thankfully) and my car is not even 4 years old. Threads like this give me serious pause for thought about refitting it. I was lucky - it seems - that when my cinch motors failed I could still get into the frunk, it just wouldn't pull it closed.
AFAIK the EvOffer one has had firmware updates that are supposed to prevent it becoming a problem in those situations...but like anything, until it actually happens I won't know.
I have an EVOffer kit installed myself and I go back and forth on wanting to remove it vs taking the chance.
You actually reminded me and I google the issue every so often and found this video:
Won't help the OP sadly, but might be worth doing as a backup in case of failure.
I asked about this and was told that for whatever reason this firmware is only available for later revisions of the kit, basically facelift M3s onwards.
For what it's worth, the cinch motors on these things are very vulnerable to moisture. I got one replaced under warranty the first time my frunk failed, and the second I had to pay for. I disassembled both failed motors and they were rusty inside. They are not sealed units, and the frunk bay is not sealed either. Moisture is a real problem generally in there.