probably not all that great, although it works better than one might expect. I have seen it do okay in a Fine Woodworking test. Someone on another forum did a test on steel bike tubes, and fluid film won
https://www.fluid-film.com/ Google seems to indicate it's very popular with automotive enthusiasts.
I think if you did use WD40, reapplying it reasonable often is a good idea. Once a year, maybe?