I can't believe they made a >21 minute video to say that foam has to be applied correctly. What a waste of time, the entire "content" could have been boiled down succinctly into a few sentences!
One of the reasons polyurethane foam is so popular, especially in confined spaces, complex geometry, or thin wall sections is due to it's R-value of ~7 per inch, and that you can get it in closed cell formulation that stops drafts, moisture problems, and air infiltration entirely. The only products I know of that are a better thermal barrier would be those commercial areogel products and vacuum insulated panels. Precast sheets of foam are great for new construction, and a lot use them in vehicles too, but it doesn't provide nearly the same quality thermal envelope as a cast-in-place product while maximizing volumetric efficiency and coverage.
They must make these kinds of videos simply for people to feel smugly superior. It's not like folks that get into these situations bother to do the commensurate research or due diligence themselves, hence the abundant source material for producers of sensational drivel like this. Such a shame. People could really use some sort of non-biased AI or search program that could quickly distill vetted information and advice to prevent these sorts of Dunning-Kruger calamities. Or perhaps a helmet of some kind that would shock them when it detects bad decision making patterns in the brain! Part of the problem is a lack of quality information full stop, when it comes to evaluating the performance and trustworthiness of "professionals" like contractors, mechanics, doctors. Professional licensure should come with fastidious statistical data collection requirements of past performance and remediation information that should be publicly available.
Along with personal finance, I think a basic risk assessment and cost-benefit analysis course would be a great addition to high school curriculum in western countries.