Add the cottage cheese, Greek yogurt, honey, vanilla protein powder, vanilla extract, lemon juice, and fine sea salt to a high-powered blender.
Blend for 2 minutes, pausing to scrape down the sides, until the mixture is completely smooth.
Fold in half of the roasted pistachios, keeping the pieces slightly chunky for texture.
Pour half of the mixture into a loaf pan. Drizzle with 1 tablespoon of honey and sprinkle with half of the remaining pistachios.
Add the remaining cottage cheese mixture and finish with the rest of the honey, pistachios, and flaky sea salt.
Cover the pan and freeze for 4 to 5 hours, until firm but scoopable.
Let the ice cream stand at room temperature for 10 to 15 minutes before scooping.