Welcome to the forum.
Metformin does have side effects in people where some find they suffer stomach issues but that usually settles down after a few weeks or when they have the slow release version. It helps the body use the insulin it produce more effectively and prevents the liver releasing glucose but diet is just as important.
Can I ask what your HbA1C was that you were prescribed metformin, the new guidelines are that for more mature people that HbA1C level should be more lenient and there should be a personalised target taking risk factors into consideration.
Metformin taken long term can affect Vitamin B12 levels so that should be checked regularly to see if B12 injections are needed.
Ideas have changed since you were diagnosed as to how powerful a low carb diet can be. Reducing carbs but making sure you have plenty of protein and healthy fats is successful for many. This link may give you some ideas for some tweaks you could make.
https://lowcarbfreshwell.com/