EDIT: the query you want to be running seems to be get all records from the 'store' table and insert them into tbl_storefinder_stores with the same values like this:
INSERT INTO tbl_storefinder_stores(store_name, store_address, lat, long)
SELECT name, address, latitude, longitude
from stores;
fiddle
If you want to create new records in the stores table for all of the records in the other table you can just do:
INSERT INTO stores(name, address, latitude, longtitude)
VALUES(
SELECT store_name, store_address, lat, long
from tbl_storefinder_stores
);
Or if you want to update the records in stores:
UPDATE stores
SET (name, address, latitude, longtitude)
= (select store_name, store_address, lat, long
from tbl_storefinder_stores
where tbl_storefinder_stores.field = stores.field) //field that is the same in both tables and won't change