Spraying overhead with kits is not a trivial pursuit.
Full coverage with foam might be wasted if the rest of the blind isn’t tight/insulated
Consider rockwool batting between rafters, then covering that with 1/4 plywood.
1/4” luan or strand board alone, sans insulation, will make a...