Fix cmake_package_source rules that cause CI failures on main

Description

Missing rules when to run the cmake_package_source job cause CI failures on main during the website update (missing tarball).

Checklist

• I have checked that my code follows the Octopus coding standards
• I have added tests for all the new features added in this request.