I eventually resolved this. There is a conflict with WooCommerce Memberships version 1.19 and BuddyPress 6.3.0. To resolve, I rolled back to WooCommerce Memberships version 1.17.5 and the page not found issue no longer appears.
Hopefully between BuddyPress and WooCommerce memberships this will be resolved in the next version.