Directly? Hell no. Piping hydrogen to homes is a nightmare.
As a method to bank excess energy (like a form of gas battery) in the form of H2 in off-peak generation hours, to use later during peak consumption? It absolutely will upturn the industry in a few years.
Got a windmill and a water source? You got Hydrogen production when you are at anything under 100% capacity. And unlike batteries, expansion only requires you add another tank, not more rare metals.