With Strong Customer Authentication (SCA) and PSD2 will my transactions be protected from fraud by Visa Secure?

Yes. You have exactly the same fraud protection as you've always had. You'll be refunded for any fraud carried out on your account, plus any interest you've paid. Your purchase protection rights, which include Section 75 and Chargeback, will stay the same, too.