I have few products in my shop, can this module still be useful to me?

Yes!

In an online store, there are necessarily pages that have no interest for search engines, such as: legal notices, terms and conditions (CGV), password recovery pages, etc.

All these pages harm your site's SEO, and deindexing them will make it easier for the pages you want to appear in search engines to rank.