[Chore] sc-32247 Fallback to use temp folder to store profile.yml

[kentwelcome]

PR checklist

• [x] Ensure you have added or ran the appropriate tests for your PR.
• [x] DCO signed

What type of PR is this? Chore

What this PR does / why we need it:

• If user's home directory is read-only, needs to find a place to store .piperider/profile.yml

Which issue(s) this PR fixes: sc-32247

Special notes for your reviewer:

Does this PR introduce a user-facing change?:

[codecov[bot]]

Codecov Report

Merging #879 (8fdfef8) into main (47999a3) will increase coverage by 0.00%. The diff coverage is 75.00%.

@@           Coverage Diff           @@
##             main     #879   +/-   ##
=======================================
  Coverage   46.46%   46.46%           
=======================================
  Files          75       75           
  Lines       10341    10343    +2     
=======================================
+ Hits         4805     4806    +1     
- Misses       5536     5537    +1     

Files Changed	Coverage Δ
piperider_cli/__init__.py	52.17% <66.66%> (+0.21%)	:arrow_up:
piperider_cli/event/__init__.py	78.12% <100.00%> (-0.23%)	:arrow_down:

:mega: We’re building smart automated test selection to slash your CI/CD build times. Learn more