Job Change Jitters

I (29F) work in a highly competitive field (software engineering) at a small company I've been with for 5 years. I really enjoy my coworkers but the company is very small and the CEO is extremely hostile towards his employees in a way I just have never felt comfortable supporting. I've stayed there as long as I have to build my resume as I started in a different field and worked my way to this position but I recently got my Master's and started putting out resumes in February.

I've had 3 initial interviews, 1 technical interview, and 0 offers not including the opportunity I'm about to dive into because that's kind of my whole point of posting. But all this is to say, it's a really competitive market out there right now and these positions are getting literally hundreds and hundreds of applicants.

I have a friend that left his previous position at a company I've wanted to work at for YEARS. The position is remote, the team seems really nice, and the pay would be the same if not more than my current position. He gave them my name and told me to apply and I did and since then, I've had 3 interviews where the people just seem over the moon invested in me because they liked my friend so much. I truly felt I absolutely BOMBED the technical interview. I didn't even finish the problem. But they were so nice about it saying they just wanted to see how I worked through a problem.

They've called me back for a final round interview and obviously I said yes but now I'm getting all in my head that they're not really taking into account my skill level and I'm going to show up and not perform to their standards. The job market is so volatile right now I truly believe if I was fired, I'd be out of a job for potentially years. I'm just so scared of messing this up and having to pick up the pieces....

My question is if they make an offer; should I take it despite my hesitations that I might not meet the criteria for the job? I'm comfortable where I am; despite my distaste for management. And again, being thrust into a job search without income sounds like a fate worse than death right now.

Any advice is appreciated and just a note, I know how privileged I am to even be considering a job offer right now...