I have to step in and defend the use of smaller formats for pinhole, although the 110 format is a bit of a challenge. By the way, it's not 110mm, it's just the designation of the cartridge format. The frame is 13 mm × 17 mm.
I use 35mm film for pinhole and often with just a 24x24mm frame.
I think this may be a misperception that "sharpness" is the highest goal in photography, and technically resolution is going to be reduced with a smaller format. But composition, light, color and subject can elevate a photograph to where you don't even notice lack of detail. Here is a recent post all done with 35mm.
https://pinholica.blogspot.com/2024/08/homebuilt-air-photography-ultralight.html
For those of you who don't want to visit that link, here's an example:
(Incidentally that's with a hand-drilled pinhole and
no sharpening, but I had to downsample the file get Photrio to accept it.)
I'm an advocate of slowing down and concentrating on each frame, but I have to say that using 35mm film gives a refreshing freedom to photography. You can put a 35mm camera in your pocket. I tend to use my 35mm cameras much like most people use their phones. I don't fool around and take multiple slightly different frames like digital photographers do, but I'm a little more lax with what I try to photograph. (btw, that post above has 33 frames out of a possible total of 36.) Exercising and practicing anything is likely to improve your results and 35mm gives you that chance to do a lot of pinhole without expending a fortune.
I think with your little camera the problem is going to be more likely the 40mm distance to the film. If you were using lenses, that would be considered telephoto. That's going to cause you more problems than just the film size. I don't want to get into a long technical definition, but you might have "sharper" results with a wider angle and a little smaller pinhole. Getting close up to things so you can see details helps that perception of sharpness too.
One thing I think that stops a lot of people with small formats is that dust and other flaws get enlarged along with the photo. You
will have to learn to retouch dust in order to appreciate the quality of your images.
So don't let the scientific rules keep you from trying things. (although it's a lot of fun to understand those rules)
Here's some examples of 110 pinhole photography that's made Justin Quinnel world famous.
https://www.pinholephotography.org/gallery