Is it dangerous being a Navy Submarine Officer?

No more dangerous than being a Navy enlisted service member. Any member of any military force must incur some risk, especially if war should break out.

That's part of the deal. To serve your country is not always guaranteed to be easy or risk free.