I've been there as well. For a 1940s era aircraft it would have presented few problems - Especially with the big, flat, Ford Island in the middle of it. - Likewise been to Taranto - You wouldn't even class that as a harbour in the geographic sense at all, at least not where the Italian fleet was anchored - Just a big bay open to the Med. Gotta wonder in both cases why more extensive anti-torpedo nets were not in place. The Germans had only had possession of Trondheim for a few months but they still managed to put anti-torpedo nets in place to protect Scharnhorst and Hipper by June 1940. Also been to the Tirpitz museum at Kaafjord - Now that's a confined anchorage.
An advantage that FAA Torpedo-divebombers had was that they could use a divebomb attack profile while torpedo bombing, so they could attack targets even in confined waters, where there was at least a few hundred yards of open water in front of the target, as they could dive vertically with the torpedo to avoid the terrain.