It sounds from reading your post that you need to have an honest conversation with your supervisor.

And - he needs to be honest with you about what's possible from this point onwards.

Currently, you are trying to sugar coat the situation and he is too nice to really challenge you. He's probably fallen into the "Ruinous Empathy" trap and it's damaging you.

You need to at least be prepared for the honest answer to be that there is no way forward.

Some questions that you both need to answer (I'm making some assumptions here as I don't know what your thesis is about).

  - Do you even know what your thesis is about?
    - What's the question it's trying to answer?
    - What's the hypothesis on the answer?
    - How are/were you going to test the hypothesis?
    - What's the conclusion going to be?
  - Do you have enough experimental results to answers any of the above
    - Is it feasible to do more experiments
    - If it's not feasible to do more, can you add in enough theoretical discussion/hand waving to get a thesis out of it