In Pirna, the last possibility is to change to the other side of the Elbe via the bridge before Dresden (Blaues Wunder) or upstream before Bad Schandau, otherwise only with a fee-based ferry. Would also recommend cycling on the left side (downstream) of the Elbe.