Should I have different financial Advisors for different purposes?

A good adviser will be able to handle both competently, though most advisers you come across tense to be more insurance people, and the only investment they know are ILPs...

Yes, I am of the view to keep insurance and investment separate. You will need to have an overview of your finances.

I am also of the view that we don't need advisers for investments. Yes, back in the days when investments were a rich man's game, we need an "adviser" (or more correctly, a distributor). These days, we have more convenient access to online brokerage, robos, DIY platforms.

Unless your adviser has access to unique and exclusive opportunities, I don't really see the need for adviser.