Needs to be dual flamethrower to be worth it.
No it doesn't.
Sturmpios greatest weakness was being shot from garrisons or heavy cover. Flamer heavily mitigates that except for at very long ranges. Any engagement in medium range sturmpios can win 1-1 more or less with the flamer.
I've found it incredibly useful.