No the Speaker of the House does not become vice-president.
If the office of vice-president is vacant, the president nominates a replacement, subject to confirmation by both Houses of Congress.
I can’t think of a case in which both the POTUS and VP left their positions vacant at the same time. What if they “convinced” Harris to resign, she did so, and then Biden died suddenly with the VP position vacant?