Is opening the link itself dangerous
In shortUsually not. What is dangerous is what you do on the page that opens.
In the overwhelming majority of cases the link leads to a page that looks like the sign-in screen of a familiar service and asks for a login and password. The loss happens at the moment of entry, not at the moment of opening.
Hence the practical conclusion: the rule is not «do not open links» but «do not enter data on a page you reached from a message». Opening the service yourself by typing the address costs ten seconds.